Percentage Fields no showing correctly in email automations

Topic Labels: Automations
Solved
741 2
cancel
Showing results for
Did you mean:
4 - Data Explorer

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

1 Solution

Accepted Solutions
17 - Neptune

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.

2 Replies 2
5 - Automation Enthusiast

Hey John!

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

17 - Neptune

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.