How/where can I change the decimal notation?

[fred_kouwenberg]

In the April release functionality on decimal notation can be changed.

Has anyone found where can I find or change this functionality?

What I'm looking for is that a decimal field uses a dot-notation as decimal separator instead of a comma-notation.
E.g. I need 12.000 for twelve thousand and not 12,000 and also e.g. Euro 12.000,50 being twelve thousand Euro and 50 cents instead of Euro 12,000.50

Thanks!

Fred K.

[fred_kouwenberg]

Ok, non of the users in the system had a Language nor a Country code field value, so the system wide should then be(come) active - but it didn't. 😮

No major problem, just did as suggested, put a default value on the fields in the user table and updated all my users with a language- and country field value.

I used:
- Country code: NL
- Language: nl

Now this did do the trick 🙂 - my decimal field(s) now change the displayed value.

But......

I don't know if the behavior that I see now is either "works as designed" or something else....:confused:

I'll explain what I'm trying to do:
- I have 3 fields: price (=decimal), quantity (=integer) and totalprice (=decimal)
- 2 client scripts: 1 onChange on price field, 1 onChange on quantity field. Both perform a calculation of the total price field via the formula "price * quantity = totalprice"

Now with the Dutch locale on my user records, this is what happens:
1. When I enter 15000 in my price field, SNC displayes this as 15.000 - which actually looks great, since this is the Dutch local for displaying; a .(dot) instead of a ,(comma) for as thousand separator.
2. However, due to my CS scripts the totalprice gets calculated and the value in totalprice (when quantity = 1) displays the value "15"

Now entering 15000 is hopefully not seen as "15".

This can either be something with my onChange CS script(s) or is the locale now indeed interpreting the entered value 15000 (fifteen-thousand) as 15 (fifteen)..?? If so, how can I get a value of 15000 entered? I tried 15000,00 - but then my totalprice displays a "Not-a-Number (NaN)" value.

I tried changing the locale to de.DE, but the result for this local is the same as for nl.NL.

I'm kind of stuck now..... looking and hoping for some suggestions/hints/tips! 😉

Fred K.

[prakashagrawal]

What function have you used in your client script to convert into number ?? I suppose you have used ParseInt.