Category 1 = 20 percent discount
Category 2 = 15 percent discount
Category 3 = 10 percent discount
Category 4 = 2 percent discount
I start by enter a 'money' field entitled "Price before discount." Then I would like to select the applicable discounts list above from the field "Discount Applied," and end up with a "Final Price."
So, If I had a $100 purchase price before discounts, and then selected "20 percent discount," I would like the calculation to multiply @Price Before Discount by 0.80 to reflect the "Final Price."
In addition, I will sometimes get multiple discounts. One from the supplier (e.g. 20%) and one from a credit card (e.g. 2%). They are not applied at the same time, so I can not simply use a 12 percent discount button. Using this scenario, I need to apply the 20% discount first, and then a 2% discount on the remaining amount. (e.g. $100*0.80 = $80; then $80*0.98 = $78.40).
I have tried using several different examples from Podio's tips and from the forum, but I can't seem to make them work for what I have described above. I keep getting a syntax error, unexpected token ILLEGAL. Any help or advice would be greatly appreciated! Thanks!