I need a formula to say:
calculate 5% of the gross value and display which ever figure is lower between 5% of 'gross value' and 'Total Outstanding'
any help is much appreciated!
I need a formula to say:
calculate 5% of the gross value and display which ever figure is lower between 5% of 'gross value' and 'Total Outstanding'
any help is much appreciated!
Hi Penny Whitlock,
The formula you would need to use would be something along the lines of:
ifElse(
greaterThan(
$total_outstanding,
multiply(
.05,
$gross_value
)
),
multiply(
.05,
$gross_value
),
$total_outstanding
)
Using the greaterThan function allows you to compare the two fields and ultimately decide which field value is displayed through the ifElse function.
Chris
Hi Penny Whitlock,
The formula you would need to use would be something along the lines of:
ifElse(
greaterThan(
$total_outstanding,
multiply(
.05,
$gross_value
)
),
multiply(
.05,
$gross_value
),
$total_outstanding
)
Using the greaterThan function allows you to compare the two fields and ultimately decide which field value is displayed through the ifElse function.
Chris