Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Nintex Community
- :
- Forums
- :
- Nintex for SharePoint
- :
- Performing calculations with Nintex Forms using th...

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Sojan,

Can you share a screenshot of your form. It should recalculate automatically.

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

I've noticed that form variables are not properly set when the form loads (see my post on this here: https://community.nintex.com/thread/9886). So if you are using a from variable in your calculation, or as a condition, it may not give you the behavior you expect on loading.

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Here is the screen shot, design mode

The calculated value controls is just use the formula sum(PTEstimate)

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Hi Bruce,

I tried with form variables and direct formula, both are not working.

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Does PTEstimate even have a value when the form loads? From your screen shot it looks like the user is first expected to select an internal order number before a PTEstimate appears in the single-line text box.

Here's a test I did with a simple form. The picture on the top is for a new form with no rows. The sum of item value is 0 because there is no item value. But when I add two rows, save the form, then open it, the calculated value is the sum of the two item values, as shown on the bottom.

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Hi Bruce,

Thanks for the reply and the effort, this scenario works for me too. The problem is once I save it and open again on edit mode, it does not recalculate. The repeat section values appear but the total will be zero. The total recalculates if I change the item value on edit mode.

Thanks,

Sojan

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Sojan:

I cannot reproduce this error in my simple test form. I suspect that something else (another control or form variable or a setting in your calculated control) is causing this behavior. Are you connecting this control to a list column that itself is a calculated field?

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Sojan,

Just reading what you wrote about the scenario, you are seeing the expected functionality as it should happen. The value is calculated on a change.

So if you start on load with "0" or null, then it will start with "0" or null. This value will then change when you add values for it to calculate by adding a row of data. When you save that form, it will show a calculated value for you. If you then view the form, the control should just display that same value that was shown before as the calculation was already done and a value was displayed.

To display a new value, you would need to change one of the values for the calculation by adding a new row or changing one of the inputs on a currently displayed row. This would cause it to recalculate the values of the control.

Hope that helps

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Bruce, I tried both connected and not connected on total calculated value control. The total calculated value control formula.

The form when it loads on edit mode

when I change the row value on edit mode

Thanks

Highlighted
##

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Sojan:

Yeah, it shouldn't do that. At this point I'm extremely curious as to why this is happening. Can you export your form and attach it to this thread?