I am working in a Nintex O365 Responsive Form. I want to calculate the Total Time for Project based on the Time Spent Per Task. The calculations for Time Spent Per Task are in a repeating section. I have a calculated value control for Time Spent Per Task. The formula is Minutes/60 + Hours. How can I get a grand total for all the Time Spent Per Task entries to appear in the Total Time for Project control?
Thank you.
Best answer by bamaeric
Hi Marnita. Make sure that the "Total Time for Project" control is a Calculated Value control and not positioned inside the repeating section. Set the formula for the "Total Time for Project" control to sum(ControlName) where ControlName is the name of your "Time Spent Per Task" control in the repeating section. That should sum up all the values of the "Time Spent Per Task" fields in the repeating section for a grand total.
Hi Marnita. Make sure that the "Total Time for Project" control is a Calculated Value control and not positioned inside the repeating section. Set the formula for the "Total Time for Project" control to sum(ControlName) where ControlName is the name of your "Time Spent Per Task" control in the repeating section. That should sum up all the values of the "Time Spent Per Task" fields in the repeating section for a grand total.
This should work the same way in a classic form, right? I am doing the same thing, but the calculated control outside the repeating section only updates with the first row. Subsequent row additions are not being reflected in the calculated control's total.
This should work exactly the same way in Classic forms for Nintex Forms for O365. One thing to make sure is that the "Total Time for Project" calculated control is outside of the repeating section. I've also seen deleting and redoing the field or the formula helps. Feel free to post screenshots and your form if you're still having trouble.
Thanks Eric, I know I've done this before, but this one is just not cooperating. I've got this single line of text control under "Total Line Price", named Data3, which I had set to currency and I also tried it as decimal. Outside of the repeating section, I added in the calculated control called "calc_total" that I want to use instead of making people add those up and enter the total in the current control next to "Total PO Price".
Here is the configuration of Data3
Here is the configuration of calc_total
In the previewer, I am seeing this behavior, the calculated control puts the first amount in there, but any additional lines aren't added. I did find one way to make it add up is by deleting an additonal row, but nothing else seems to trigger it.
So far, I tried recreating that calculated control and changing the types from currency to decimal and string. Any other thoughts on this are much appreciated!
Thanks for the information. Your configurations look correct. I just tried it with the same settings in your screen shots and it worked for me. Make sure that the Data3 control is actually in the repeating section.
It looks like your using Nintex Forms for SharePoint 2013? If so, which build are you on? You can get that by going to the Help section in the Ribbon and selection "About Nintex Forms".
I just deleted and recreated the Data3 control to make sure, but same behavior persists. It's strange that it will calculate if I delete a row. Here is the Version: 2.11.0.1
I checked against the Nintex Forms 2013 - Release Notes and there were some bugs fixed related to the Calculated Value and Sum control function by newer builds. These could be related to what you're seeing.
Build 2.11.2.20 - Fixed an issue where the Sum function may not calculate on New and Edit mode (00184821).
Build 2.11.1.0 - Fixed an issue where the Calculated Value control Sum function may not calculate correctly (00187034, 188130, 00189661).
Best next step might be to update Nintex Forms or open a ticket with Nintex Support.
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.