Hi
I am currently trying to get this field to calculate 10% of gross value if the net value is under £50,000.
if the net value is over £50,000 then I need the field to equal £5,000 plus net value x (VAT rate/100)
i.e. if VAT rate is 20 (20% vat) and the net value is over £50,000 then the 10% payment amount should be £6,000 (net value of £5,000 plus £1,000 VAT)
if the VAT rate is 0 and the net value is over £50,000 then the 10% payment amount should be £5,000 (net value of £5,000 plus £0 VAT)
this is what i have so far:
ifElse(
greaterThan(
$pr_net_value_c,
"50000"),
add("5000",(multiply($pr_net_value_c,(divide($pr_payment_rate_c,100))
ifElse(
subtract(multiply($pr_payment_gross_value_c,.1),$pr_total_paid_c)
)
thanks so much for any help in advance