I have an order form using Nintex forms. It shows a list price in one field (currency), then there is the partner discount % in another field (decimal) and I want to show the partner price in a different field (Currency).
But i cant seem to find the right formula to build to work this out, anyone got any ideas please?
Best answer by brent_read
Hi Andy,
That depends a bit on how you’re listing the partner discount. The formula for that should be {ListPrice} * (1- {PartnerDiscount) if the partner discount is just a decimal or {ListPrice} * (100- {PartnerDiscount)/100 if the partner discount is being shown as a whole number (eg .3 vs 30%).
That depends a bit on how you’re listing the partner discount. The formula for that should be {ListPrice} * (1- {PartnerDiscount) if the partner discount is just a decimal or {ListPrice} * (100- {PartnerDiscount)/100 if the partner discount is being shown as a whole number (eg .3 vs 30%).
You can use a combination of a form variable (to calculate the Partner Price) and a form rule (to display to final Partner Price). Below is how I was able to accomplish this.
Create fields for List Price (Currency type), Partner Discount (Number type with decimal), and Partner Price (Currency type).
Create a Form Variable to calculate the Partner Price with these settings: - Name = decPartnerPrice - Type = Decimal - Value = Form.List Price * (1-(Form.Partner Discount/100))
Create a form rule with these settings: - Name = Calculate Partner Discount - If “List Price” Is filled AND “Partner Discount” Is filled - Then “Partner Price” Value decPartnerPrice - Else “Partner Price” Value 0.00