Formula in an invoice template : Support Center

Answered

Formula in an invoice template

started a topic over 4 years ago

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

said over 4 years ago

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

said over 4 years ago

Thank you so much, that works, just a pesky = sign then!