Number format issue - comma (1,5) instead of period (1.5) before decimals?

[Former Member]

I am using an input field of data type Number. In Norway we use a comma before decimals. I can't get this to work in VC. Have tried to set Number format with 'Local format' checked but this is not helping. (even if my portal is showing Norwegian texts as supposed by the language setting)

If I uncheck this and go to Custom formatting I get to set my own format. NSTR(@OPERATORER_N, ".2") gives me two decimals but with a period as the decimal point. NSTR(@OPERATORER_N, ",2") does not work.

I do not want thousands separator.

Tips?

Henning Strand

[Former Member]

Hi,

Check the se Threads i think you definitly get the idea or solution.

But every body ask about to get dot separatot instaed of Comma Separator since this can be get easyly with Language Portal Settings

http://help.sap.com/saphelp_nw70/helpdata/en/38/2d9b732beb4c68bba2962602a7d6bd/content.htm

http://help.sap.com/saphelp_nw70/helpdata/en/26/64fb472a144a0dbaf88f5ec75d9270/content.htm

http://oregonstate.edu/dept/computing/warehouse/PDF/8-reports.pdf

All the best

Govindu

[Former Member]

Thanks, Govindu

I saw these threads before but all seem to be related to the thousands separator, not the decimal point. I have not seen that the decimal point changes between comma and period based on the language.

I did though use the same idea that some are using and set: REPLACE(NSTR(@OPERATORER_N, ".1"),'.','.')

This still displays a period in the input field, but the value is passed to the back end with a comma, which is the most important. Also the user can type in the number using a comma or a period. Both now work.

Henning Strand