I am trying to calculate sum of amount field which is inside repeating section. Formula used to calculate sum is sum(Amount). When I open the form in edit mode, the calculated field turns to 0 (see snapshot below). To update the amount, i have click either inside amount field or add new row.
Gone through lot of articles but none of them helped. All of them pointed to Nintex version issue but i have Nintex version being used in 188.8.131.52
Solved! Go to Solution.
I would need to see the Formula inside of your calculated control. It should be pretty straight forward though.
Here is an example form (only pay attention to the controls that are highlighted in yellow):
I have one Control named (someNumber) in the Repeating Section and a Calculated Control named (totalControl) just on the Form outside of the Repeating Section.
Here is how the Single Line Text (someNumber) is configured:
Here is the formula in the Calculated Control:
Running the form in Edit mode it behaves like one would expect.
there are no other rules running, no other code. just the calculated formula. please copy this style and get back to me.
I found the solution by back tracking.
The repeating section is placed inside panel and that panel has rule applied to it based on lookup value. Since there are lot of values, lookup is taking time to resolve and in the mean time sum is calculated as ZERO. I removed that rule from panel and now it is working fine, sum is getting re calculated.