Hello,
I am getting my feet wet with Zoho and I am testing some simple calculations to get familiar with Forms and Formulas. This seems very simple and I have tried to look at examples but I cant get it to work.
I have the following:
A sub total field
Several fields(tiers) that hold a dollar amount that will be compared to the sub total
Several fields(tiers) that hold a commission amount that is associated to the dollar amount .
This is what should happen:
If the sub total is less then or equal to a dollar amount I calculate the commission by multiplying tier amount by the tier commission then divide by 100
This is my statement:
if (${Quotes.Sub Total}<= ${Quotes.Tier 1 To Amount}, ${Quotes.Tier 1 To Amount}
*${Quotes.Tier 1 Commision})/100)
I get a syntax error message that says 'Missing braces'.