AnsweredAssumed Answered

Inserting or editing a record with calculated field cause a decimal separator issue

Question asked by Federico Ricci on Mar 24, 2016
Latest reply on Aug 25, 2016 by Johan Thieffry

Hi all

I use SugarPRO build 9, and i have configured some custom modules. In one of these modules i have some calculated fields. If I do a massive data import, the values are calculated well and nothing goes wrong, but when I edit a single record or when I try to create a new one, there are some troubles. Editing the fields used as the formula elements if the result is larger than 1000 (one thousand) the calculated field change the way to set comma and dot and invert their use.
I'm usign comma to separate decimals and dot as 1000's separator. In the calculated field, if the value is larger than 1000 javascript front end change the order setting comma as 1000's separator and dot for decimal notation.

This result in an error for a calculated field that is not possbile to solve manually.

Where It can be possible to change this behaviour?

Thanks in advance for any reply.

Best regards,