ifElse( greaterThan($pr_total_paid_c, multiply($pr_payment_gross_value_c,.45) ,"0", ) ifElse( subtract(multiply($pr_payment_gross_value_c,.45)), $pr_10_percentage_suggested_c, $pr_total_paid_c)
Please tell me where i have gone wrong with this formula - Im not sure why it is not working, i think i just have my brackets misplaced!
I am trying to do
If Total Paid is more than 45% Gross Value put "0"
otherwise, workout 45% gross value minus 10% suggested field value minus total paid
Any help is greatly appreciated!
