Display currency number format for Polish Language

D365FO
1

I am trying to display the number based on specific language. However, the out of the box number format for Polish language is not as expected.
e.g.
23,560.05 (en-US)
23 560,05 (pl) The required format is 23.560,05 (instead of space I want to display period for thousand)

I tried the format function but for some reason it is not working.
format(SalesInvoiceHeaderExt/Amounts/@InvoiceAmount,‘#.###,##’,‘pl’)
It displays as 23560

2

Hi @MAzam,

If the Polish culture format by default isn’t giving you the desired result, you might want to try a different culture. You could use the German culture instead:

format(SalesInvoiceHeaderExt/Amounts/@InvoiceAmount, ‘n2’, ‘de’)

This should give you the correct output in the format 23.560,05.

3

Thanks, @AmirO
When I used the culture as suggested then got this output.
23 560,05
It seems there is a kind of configuration setting somewhere which doesn’t allow to display period but to show space.

Update: Sorry, my mistake because I used the language parameter as “pl” instead of “de”. Now it is showing correctly