Hi,
Can anyone help with some formula in an invoice template (in desktop mode)
I'm trying to create:
If the subtotal is less than 10.99, then value is the subtotal, otherwise 10.99
EVAL{BEGIN}IIF[[{Subtotal}]=<10.99,[{Subtotal}],"10.99"]{END}
Is this right as it shows as EVAL ERROR failed to evaluate the rule
Many thanks
Hello,
Thank you for your question.
Please try this formula: EVAL{BEGIN}IIF[[{Subtotal}]<10.99,[{Subtotal}],"10.99"]{END}
Kind regards,
Julietta
Technical Support
Thank you so much, that works, just a pesky = sign then!
Jacqui Connor
Hi,
Can anyone help with some formula in an invoice template (in desktop mode)
I'm trying to create:
If the subtotal is less than 10.99, then value is the subtotal, otherwise 10.99
EVAL{BEGIN}IIF[[{Subtotal}]=<10.99,[{Subtotal}],"10.99"]{END}
Is this right as it shows as EVAL ERROR failed to evaluate the rule
Many thanks