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
