Comma in thousand separator being read as a dot

[JennyFlaherty]

Hi All

I have various clients scripts running which set numerical values in certain fields based on the text value of other fields.   I then have calculations set up on these numerical fields to compare the differences.

Everything is working fine, until I set a number which is more than 3 digits, ie 9,999.   In the calculations, SN seems to be reading this as 9.999 (ie replacing the comma with a dot), therefore my calculations are not working out correctly.

Can anyone tell me what I need to do to resolve this?

Many thanks

Jenny

[rushputin]

This probably has to do with your localization settings: not every language uses commas as thousands separators and periods as decimal separators.

Some swap them: so, one thousand and a half would be '1,000.50' in English and '1.000,50 ' in Spanish.

[gbernuetz · Accepted solution]

try this: http://wiki.servicenow.com/index.php?title=GlideForm_(g_form)#getDecimalValue

[JRego]

Can't access this link. Could you please send the correct link?

[JennyFlaherty]

Thanks to you both for your replies, I really appreciated it.

Richard, I had already checked my localization settings, and they are correct.

Guido, using the getDecimalValue corrected the issue.   Thank you so much.

Regards

Jenny