How to handle international number formats in WebServices using variables?

Hi,

To show the numbers in the local format, we use the browser settings. This works fine for showing the numbers in the tables.

Now we have a new report, were we color the cells of the table, depending on a reference value. This reference value is stored in a variable with the value 0,002
Viewing the table with "German" setting, it looks good. Viewing it with "English" settings, the numbers are shown correctly with . as decimal separator and , as thousands separator but the table isn't colored because the reference value isn't "translated" to the new number format. Therefore the value "2" is taken instead of "0.002".

Is there any way to fill the variable correctly to use the value in different number formattings? Or any trick to use it in a formula?

Best regards,

Sylvana

Find more posts tagged with

Infor EPM Discussions

Comments

Nick Gladkov

I would try using VALUE() function for that and if this doesn't work, you can also have report start action where variable is equal to 2/1000

Sylvana Neydek

Value() was the first thing I thought of, unfortunatelly, this doesn't work.

The action is a good idea to avoid any fixed decimal seperators in the variable value. Thanks.

ivan-rebo

In 12.0 we added a VALUENEUTRAL function that always expects the input text to be english format. You would need to change the way you store the values in the variable to always store the english format but at least it will then always work no matter what settings are coming from the browser.

Copyright © 2025 Infor. All rights reserved.