Currency Format in Email

[Sharon_Visser]

I have a field defined as Currency however when I add that field to the Message section of an email that I am creating from an Automation, the value does not appear as Currency. It does have the decimal point for the cents, and I can easily add “$” as part of the preceding text, but I would really like to see the commas that are part of the defined format on the field. Any ideas?

[Lu]

The best way to do this is with the same kind of script step as in the accepted solution, but use Intl.NumberFormat as per my answer in another thread.

@Camanzi  I also updated my formula version so that it handles negative values and amounts less than 1 currency unit. You would need to change the currency from "$" to "R$ " and then swap the commas and decimal point.

[devynoshea]

this is giving me a blank in my email automation any idea why that might be? 

[Lu]

Use console.log(...) at various points in your script to check the values of your input and output variables when testing it.

Post a new help question if you continue to have trouble, unless you can contribute more information that will help others resolve the original problem.