How do I calculate the values from individual fields?
Hello,
I am looking for a way to calculate the values from individual fields in the module "Invoices".
- "Sub_Total" (it's the "offical" field of the Products subform)
- "Discount_in_Percent" (picklist)
- Result: "Discount_Value" (input field)
The result should be a value in USD. So the calculation should be:
USD 130.00 (field "Sub_Total") * 30 (picklist "Discount_in_Percent") / 100 = Result: USD 39 (field "Discount value")
How can I achieve this?
Thanks for help,
M.