Hello, I have these fields:
- Discount Type
- Discount Amount
Price is currency
Amount is just a number (quantity)
Discount Type is a value list with either "Percent" or "Amount"
Discount Amount is a numeric value. It could be a standard, flat "Amount" or it could represent the percentage discount, eg if it is 10 and the Discount Type is "Percent" that would mean 10%
Total (currency) should be calculated depending on Discount Type.
What would the calculation be in order to get the correct Total?
Thanks in advance