Help

Percentage Fields no showing correctly in email automations

Topic Labels: Automations
Solved
Jump to Solution
619 2
cancel
Showing results for 
Search instead for 
Did you mean: 
John_Townsend
4 - Data Explorer
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
Bill_French
17 - Neptune
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.

See Solution in Thread

2 Replies 2
49erAllie
5 - Automation Enthusiast
5 - Automation Enthusiast

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
17 - Neptune
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.