How can I format prices with a period for the thousands separator and a comma for the decimal separator with two decimal places?
Some countries use the period character as the thousands separator and the comma character as the decimal separator when formatting currencies.
You can use the format_as_money() function in the Calculated Fields to do this:
Examples:
replace_multiple_characters(format_as_money({{ total_price }}), '{",": ".", ".": ","}')
If the value of "total_price" is "12345.95", this will output: 12.345,95
If you need to add the currency symbol and the currency code, you can do something like this:
"€" + replace_multiple_characters(format_as_money({{ total_price }}), '{",": ".", ".": ","}') + " EUR"
If the value of "total_price" is "12345.95", this will output: €12.345,95 EUR
Related Articles:
App: EZ Exporter
Tags: formatting