Answered

Formula in an invoice template

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


Answer

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!


Login to post a comment