Percentage Fields no showing correctly in email automations

[John_Townsend]

When incorporating a % field into an email to be sent by an automation, it converts into a decimal in the email automation.

[49erAllie]

Hey John!

I have a workaround that may help you out!

Create a formula field

Your formula is going to be
CONCATENATE(({Percent}*100), “%”)

(replace {Percent} with the actual name of your percentage field)

In english, this formula says
Take this decimal, multiply it by 100, and then create a text string that appends the result of that multiplication with a “%” symbol

You can use this field when creating your automation, and it should correctly format as a percentage in your email

[Bill_French · Accepted solution]

John_Townsend:

it converts into a decimal in the email automation.

To be clear, the conversion happens in the per cent field; the data is a decimal which is rendered as a percentage in the column. The email system is simply rendering exactly that which is in the field unless you tell it to interpret that field differently as @49erAllie demonstrated.