Solved

Finding the correct result for a % sum

  • 16 April 2024
  • 4 replies
  • 33 views

Userlevel 1
Badge +4

Hi All

 

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?

icon

Best answer by brent_read 16 April 2024, 18:37

View original

4 replies

Userlevel 1
Badge +4

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%).

 

Regards,

 

Brent

Userlevel 5
Badge +13

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.

  1. Create fields for List Price (Currency type), Partner Discount (Number type with decimal), and Partner Price (Currency type).
  2. 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))
  3. 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
  4. Test it out in the Preview tab.

 

Userlevel 5
Badge +13

Looks like @brent_read beat me to the punch.

Userlevel 1
Badge +4

@bamaeric 

Yeah, but your response was much more thorough 😀

Reply