Bug in Calc field
Posted: Thu Feb 08, 2018 4:29 pm
The Calc field has a bug when dealing with Norwegian (Scandnavian) number formats.
When my form tries to sum up values in the the sub firm wich has the format "1.000,00", it doesn't reckon the "," as a decimal separator. Thus "1.234,56" is reckoned as 123456 when it sums up, and all my form numbers became 100 times bigger than they should.
Changing the format to "1000.00" solved the problem. This is a well known JavaScript problem.
When my form tries to sum up values in the the sub firm wich has the format "1.000,00", it doesn't reckon the "," as a decimal separator. Thus "1.234,56" is reckoned as 123456 when it sums up, and all my form numbers became 100 times bigger than they should.
Changing the format to "1000.00" solved the problem. This is a well known JavaScript problem.