When incorporating a % field into an email to be sent by an automation, it converts into a decimal in the email automation.
Answer
Percentage Fields no showing correctly in email automations
+1Best answer by Bill_French
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.
+4Hey 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
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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.