Not applicable

Calculated Value - SUM wont show value over 1000

Hi,

 

I have a repeating section on an order form, beneath this I have a total field as a calculated value. This is here to calculate the sum of the order totals in the repeating section. Using sum(Total) in the calculated field works perfectly until the value goes over 1000. When this happens the value sits at 0.

 

I have attached an image of what is happening

0 Kudos
Reply
3 Replies
xMikeX
Automation Master
Automation Master

Re: Calculated Value - SUM wont show value over 1000

Hi Ryan,

I'm going to guess its the comma "," in the numeric value that is interfering.  It might be trying to treat that value as a String which would cause the sum to fail.  See if removing that would fix the issue.

Thanks

0 Kudos
Reply
Not applicable

Re: Calculated Value - SUM wont show value over 1000

Hi,

 

Thanks for the reply.

 

That has worked, we changed the two values in the repeating section to strings which has resolved the issue.

0 Kudos
Reply
xMikeX
Automation Master
Automation Master

Re: Calculated Value - SUM wont show value over 1000

No problem Ryan, if you could mark my answer as correct that would helpful to others.

0 Kudos
Reply