convert number to currency in emails

[johnw]

after POs are booked and my recipe sends emails out to Sales and OMs to let them know what happened the prices are hard to read since there is no formatting.

for example they see:

Op Amount: $3891266.55 (USD)

they would like to see:

Op Amount: $3,891,266.55 (USD)

this seems like it's an easy ask but I can't figure it how to do it

thanks

john 

[gary1]

Sounds like you need .to_currency

[johnw]

is it that simple???

  in the html body of an email I have it set something like this

<strong>PO Amount: </strong>   $<Amount Data Pill><br/>

[gary1]

It all depends on how your email body is written AND if you have more than one dollar amount per email.

If your email only has one amount, I would make a logger or variable, convert it with .to_currency, and then swap the data pill in the email body.

If you don't want to burn the task, then you'll have to switch your email body to formula mode, and use .to_currency on the amount in the body, and concatenate it back together.

If you have multiple values, then it'll probably be a combination of a list or multiple variables to hold the conversions, and then implementing them into the email body.

[shivakumara]

Hi @johnw ,

Try with below formulae. Hopefully it solve your problem. 

Just add the data pill in HTML body.  
<strong>PO Amount: </strong>   $<Amount Data Pill><br/>


@gary1 ,

You were right, but we need to modify little bit based on the Ask.

Thanks and Regards,

Shivakumara Avadhani