Forms 10.1 Table Calculation Bug

posted on May 12, 2016 • Show version history

Hi,

I started using the newly added calculation functionality for tables and collections in forms 10.1

The calculation that I am doing is in a table and I noticed that when a field value is more than 999,999 the calculation does not add that field.

This is the formula that I used.

=SUM(INDEX(Age_Analysis.V_0___30,ROW()),INDEX(Age_Analysis.V_31___60,ROW()),INDEX(Age_Analysis.V_61___90,ROW()),INDEX(Age_Analysis.V_91___120,ROW()),INDEX(Age_Analysis.V_120_,ROW()))

All of the fields in this table are 'Number' fields.

Please let me know if you have any suggestions on why this could be happening.

0 0

posted on May 12, 2016

Hi François,

This seems to be a bug (SCR 144105) when using the SUM calculation for elements in a row of a table (1) when the field value is larger than 999999, and (2) when the thousands delimiter is enabled. Can you confirm that if you go into the Field Options of the columns which are being summed, and uncheck "Use thousands delimiter", the SUM formula works correctly?

Thanks for bringing this to our attention.

0 0

View 3 previous replies

replied on August 29, 2016

Hi James,

I have also experienced this issue and I can confirm that removing the "Use thousands delimiter" does fix the issue.

Unfortunately, I do need the "Use thousands delimiter" to be activated.

Thanks

Ian

0 0

replied on August 29, 2016

This particular issue has been fixed and will be part of the upcoming Forms 11.

1 0

replied on August 30, 2016

Thanks James

0 0

replied on January 12, 2017

This issue has been fixed in Forms 10.2

0 0

replied on January 25, 2018

I observed that the thousand delimiter causes very odd behavior when using Javascript code to compare values. Specifically, I had code to change the background color of the field if it was < X, where X was changes based on the value of a second field. It didn't work correctly until I turned off the thousand delimiter in all fields involved. Is that part of the same bug? I am on forms 10.2.1.246

0 0

replied on February 9, 2018

My issue was fixed by using parseInt to remove the thousands delimiter: https://answers.laserfiche.com/questions/135312/Thousands-delimiter-breaks-my-code#135326

0 0

Discussion

Discussion

Forms 10.1 Table Calculation Bug

Comments 0

Follow-Ups 1

SCR Filed

Sign in to reply to this post.