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
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.