cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Performing calculations with Nintex Forms using the calculated value control

You can use the Calculated value control to perform a calculation on a form, which will display on the form when it is used.

To watch an example of how to use the Calculated value control, we have a video of an online order form, which uses the calculated value control to calculate a line total, as well as the total amount for the order. This example applies to both Nintex Forms 2010 and 2013.

Labels: (3)
Reply
33 Replies
Community Manager Community Manager
Community Manager

Re: Performing calculations with Nintex Forms using the calculated value control

I had a tough time with the calculated fields until I realized how Nintex was using the fields.  Big note here....You MUST use the named controls in order for it to use the values correctly.  Took me way to long to figure that out.  I will repeat, use the Named Control when calculating fields. 

Reply
shaunlub
Nintex Newbie

Re: Performing calculations with Nintex Forms using the calculated value control

I'm glad I found your comments here Eric. I just could not think why the calculation was not working. But you put me on the right path. Thank you. An extra point here - the inputs for calculations should NOT be connected to list columns or the calculation will just not start.

Reply
robwatts
Nintex Newbie

Re: Performing calculations with Nintex Forms using the calculated value control

Sometimes the 'logic' of Nintex Forms/workflow seems a little bizarre, still it's all an interesting learning curve. 

Reply
jacobarn
Nintex Newbie

Re: Performing calculations with Nintex Forms using the calculated value control

For some reason as soon as I add another line item it won't calculate the line item total or the grand total. It calculates just fine if there is only one line though.

Nintex Forms.PNG

0 Kudos
Reply
Highlighted
Community Manager Community Manager
Community Manager

Re: Performing calculations with Nintex Forms using the calculated value control

Jacob,

Care to share your formula? If it was working for one line, I'd think there may be a small glitch stopping it from updating for multiple.

0 Kudos
Reply
jacobarn
Nintex Newbie

Re: Performing calculations with Nintex Forms using the calculated value control

Nintex Forms.PNG

Both Quantity and UnitPrice are Named Controls

0 Kudos
Reply
Community Manager Community Manager
Community Manager

Re: Performing calculations with Nintex Forms using the calculated value control

Jacob,

Here is what you should have...

Your fields should be single line of text for Qty and Unit Price and a Calculated control for Totals.  They should also be named controls as you stated, but put into a repeating section as one row. See above

Your item level total should have the formula as you are displaying it. 

Your Invoice Total should have the following formula sum(Invoice Total)

Then when you add rows to the repeating section, it should automatically calculate those for you.

Reply
jacobarn
Nintex Newbie

Re: Performing calculations with Nintex Forms using the calculated value control

That's exactly what I had. I did change the 'recalculate formula on view mode' to yes and tripled check to make sure the calculated field was in the repeating section which it was. But I also made the the repeating section a little bit bigger so the 'X' wasn't overlapping the line item total field and now it is working. Maybe I just had the calculated field a little too close to the edge and wasn't in the repeating section?

Nintex Forms.PNG

Reply
sojanm
Nintex Newbie

Re: Performing calculations with Nintex Forms using the calculated value control

Hi Eric,

Any idea why it does not calculate the total when the form is loading. It is just gives me zero, but when i change the row value it calculates the total for all the rows. I have the recalculate to "yes" for the three modes. I tried using form variables but didn't help.

Sojan

0 Kudos
Reply