Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Percentage Fields no showing correctly in email automations

Topic Labels: Automations
Solved
Jump to Solution
1252 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.