cancel
Showing results for 
Search instead for 
Did you mean: 
AmanG
Nintex Newbie

Calculated field inside repeating section turns to 0 in edit mode

Jump to solution

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 3.3.1.0

AmanG_0-1610374296629.png

 

Labels: (1)
0 Kudos
Reply
5 Replies
AmanG
Nintex Newbie

Re: Calculated field inside repeating section turns to 0 in edit mode

Jump to solution

@MegaJerk Hi Meg, could you help me please as in the past also your solutions and suggestions have helped me.

0 Kudos
Reply
MegaJerk
Automation Master
Automation Master

Re: Calculated field inside repeating section turns to 0 in edit mode

Jump 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): 

MegaJerk_0-1611551478705.png
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:

MegaJerk_3-1611551805205.png

 

 

Here is the formula in the Calculated Control: 

MegaJerk_1-1611551663356.png

 

Running the form in Edit mode it behaves like one would expect. 

MegaJerk_2-1611551727547.png

 

there are no other rules running, no other code. just the calculated formula. please copy this style and get back to me. 

 

 

0 Kudos
Reply
AmanG
Nintex Newbie

Re: Calculated field inside repeating section turns to 0 in edit mode

Jump to solution
Hi Meg, Thanks for taking out time for this. I agree with your solution and even I am not able replicate the issue in test site. It's working as expected in test site but not in production. I have JavaScript and workflows running in backend so really not sure what is causing the sum to be zero.
0 Kudos
Reply
AmanG
Nintex Newbie

Re: Calculated field inside repeating section turns to 0 in edit mode

Jump to solution

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. 

View solution in original post

0 Kudos
Reply
MegaJerk
Automation Master
Automation Master

Re: Calculated field inside repeating section turns to 0 in edit mode

Jump to solution

Good to hear! Sometimes all it takes is another more detailed look. We've all been there and made that mistake. 

0 Kudos
Reply