Skip to main content
Nintex Community Menu Bar
Solved

Calculate two columns

  • August 22, 2021
  • 2 replies
  • 66 views

please help me guys 🙂 I need to calculate two fields and the result on another field, as you see in the below photo I need Value= Quantity * Price 

19356i76E3813C6CC547B8.png

 

Best answer by Aleximo

Is this a responsive form?

 

Then you would have to set it up like this:

 

 

 

When Quantity and Price arent empty then set the value of "Value" Quantity * Price.

 

For the Total Value just set the formula to:

 

if one of Price or Quantity is empty u could add a second rule that Value is in that case 0:

 

 

2 replies

Forum|alt.badge.img+8
  • Answer
  • August 23, 2021

Is this a responsive form?

 

Then you would have to set it up like this:

 

 

 

When Quantity and Price arent empty then set the value of "Value" Quantity * Price.

 

For the Total Value just set the formula to:

 

if one of Price or Quantity is empty u could add a second rule that Value is in that case 0:

 

 


  • Author
  • August 23, 2021
thank you so much 🙂