Question

Is there any provision to display decimal amount with grouping of digits according to country ?

1

Hi All, Problem : In our UI we are showing the amount as 123456.789 but we want to show it as 1,23,456.789 according to different country standards. But many other countries use the comma and period as 123.456,789. So how could we achieve this by using Mendix functionalities? Tried Solutions : I have tried using formatDecimal(1234.56 , ‘#,###.#’) → this function return output depending on the language we set. I have also tried Group digit, it sets only to comma format. Thank you.

asked 2021-07-15

Shivprasad Jamdade

2 answers

Ragul Raj · Answer 1 · 2021-07-21

Hi Shivprasad ,

I hope this widget will help you.

https://marketplace.mendix.com/link/component/116191

Tim v Steenbergen · Answer 2 · 2021-07-15

Nope. You would expect this to be both a country-setting and a user-account setting. Defaulting to the country-setting if the user has not set its own preferrence. But alas, no. Apparently Mendix choose to stick to 1,234,567.89.

More people have run into this: https://forum.mendix.com/link/questions/108406

Btw. I hope to get corrected on this and that somebody comes up with a solution.