AnsweredAssumed Answered

Conditional Calculation

Question asked by mkrokos on Dec 18, 2018
Latest reply on Dec 18, 2018 by mkrokos

Hello, I have these fields:

  • Price
  • Amount
  • Discount Type
  • Discount Amount
  • Total

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