I'm having issues with Nintex Forms 2013. I have a repeated section that multiplies cost * quantity to a total cost for service field per row. I also have a total cost field outside the repeated section that sums the total cost for service in the repeated section using a Sum(TotalCostForService) formula. Both the total cost for service and total cost calculated fields are set to re-calculate on new/edit mode. The calculations are working perfectly in new mode and in view mode. The only issue I'm having is in edit mode, the total cost field outside the repeated section shows 0 on load and if I save it, that value gets saved to my list column. If I add or remove a row, the total cost on the bottom does re-calculate properly and gets saved properly.
Picture below showing the total cost is not updating properly in edit mode:
Picture below showing correctly in view mode:
Solved! Go to Solution.
does the vale recalculate if you just change some of existing values (so without adding/deleting row)?
do you have rules or appearance settings applied on controls?
check developer console whether there are not reported any errors.
try to place one another calculated value control on the form outside of RS and sets its formula simply to TotalCostForService. how does it evaluate?
Yes, the field is set to recalculate. I think it's because my workplace is on a version older than 9.1.20. It appears that 9.1.20 has some fixes for edit mode so I'm going to get my server admins to upgrade and see if that fixes it.
Yes, I had a look at the release notes and found that 9.1.20 had some fixes to some bugs regarding calculated fields and edit mode. Had to send in a support ticket to get that specific installer version as I didn't want to go all the way to latest.