Skip to main content
Solved

% Field not displaying correctly in Automation Email


Forum|alt.badge.img+4

I am trying to create an automated email with inserted % fields. However the percentage is not showing up correctly.

For example, the % for the record is 55.50% and it is showing as 0.55% in the email.

I've attached screenshots of the Automation Email, Email Preview and the actual Record.

 

Thanks!

Best answer by Zack_S

Hi @Jewels9582 I would recommend creating a 'helper' formula for both fields and use that in the email. 

  1. Add a new formula field

 

Avg Video Play % * 100

 

  • Add a second formula field

 

% Exp Complete * 100

 

  • Use those fields in your email
View original
Did this topic help you find an answer to your question?

2 replies

Zack_S
Forum|alt.badge.img+15
  • Inspiring
  • 95 replies
  • Answer
  • August 31, 2023

Hi @Jewels9582 I would recommend creating a 'helper' formula for both fields and use that in the email. 

  1. Add a new formula field

 

Avg Video Play % * 100

 

  • Add a second formula field

 

% Exp Complete * 100

 

  • Use those fields in your email

Forum|alt.badge.img+4
  • Author
  • New Participant
  • 4 replies
  • August 31, 2023
Zack_S wrote:

Hi @Jewels9582 I would recommend creating a 'helper' formula for both fields and use that in the email. 

  1. Add a new formula field

 

Avg Video Play % * 100

 

  • Add a second formula field

 

% Exp Complete * 100

 

  • Use those fields in your email

Hello Zack, 

I tried the suggest formula, it wasn't working so I looked up formulas and it said to use curly brackets with multi-word field names so I tried {Ave Video Play %} * 100 and it seems to be working.

Thanks so much for the help!

- Julie


Reply