Final balance Calculation help

I am trying to calculate the final balance on a clients account 

i want to write:

if the checkbox for 90% received is not ticked then multiply gross value x 0.05 (to get 5%)

if the checkbox is ticked, do gross value - 10% suggested - 10% amount paid - 35% suggested - 35% amount paid - 90% suggested - 90% amount paid - additional payment 1 - additional payment 2 - additional payment 3 - additional payment 4

i feel that the code is correct but its throwing out parenthesis error again Disappointed

is there any guides on how to use the parenthesis correctly?

ifElse(
equal($pr_90_percentage_received_c,0),
multiply($pr_gross_value_c,0.05)
ifElse(
equal($pr_90_percentage_received_c,1),
subtract(
$pr_gross_value_c,
$pr_10_percentage_suggested_c,
$pr_10_percentage_amount_paid_c,
$thirthyfive_amount_paid_c,
$pr_90_percentage_amount_paid_c,
$thirtyfivepcent_suggested_c,
$pr_90_percentage_suggested_c,
$pr_additional_payment_1_c,
$pr_additional_payment_2_c,
$pr_additional_payment_3_c,
$pr_additional_payment_4_c,
)
)
)

Parents Reply Children
No Data