Comma as Decimal point and Dot as tthousand separator

[Former Member]

Hi All,

I have a requirement to display comma ( , ) as the decimal point and Dot ( . ) as the thousand separator on the UI grid (type : scoreboard ). For example if this is the actual value 1958425.16 and it needs to be display in this format , 1.958.425,16.

I have tried to use 0,00 format in the NUM format area of the display template . but getting error message : MalFormed pattern.

Please advise .

Regards,

Laboni

[Former Member]

Laboni,

You can do it as suggested by Manoj which is usually the best way (since its closer to the source). However, you may want to try a simpler way of using 2 [currency signs |http://en.wikipedia.org/wiki/Currency_(typography)]together. Copy the symbol from Wikipedia and paste them into the format column in the grid DT. You may need to experiment them in a group with other formatting options to get what you want. I found it in the 11.5 help ([here |http://help.sap.com/saphelp_xmii115/helpdata/en/Getting_Started/Template_Editor/iGrid_Editor.htm]> Layout and Formatting Properties > NumberFormat) and tried it in 12.2. For me, it defaulted to USD.

Good luck,

Kevin

[Former Member]

Hi Laboni,

As per my understanding in SAP MII 12.1.5 we can not perform such operations with integer spacially with dot (. stands for decimal place).

You can do it in BLS and take output as string (as per your required format) then you can display on grid.

That is the another way to fulfil your requirement.

Regards,

Manoj Bilthare