Adjust email sender in automation

[Jewels9582]

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!

[Zack_S · Accepted solution]

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

[Jewels9582]

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