Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Automation Email: Rounding

Topic Labels: Automations Formulas
345 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Turnerhayley195
4 - Data Explorer
4 - Data Explorer

I need the dollar amounts on our automated emails to be automatically rounded to the nearest cent. The automated email is pulling these figures from fields in airtable that have formulas associated already, and they are set to round to the nearest cent/hundredth, however when they come through on the automated email suddenly they include an extra place value "thousandth," and do not provide thousands comma markers or dollar signs. I do not know how to combine a ROUND formula on top of the formulas that are already on the fields. Can someone help? 

2 Replies 2
ibayub
6 - Interface Innovator
6 - Interface Innovator

have you tried wrapping in a ROUND and multiplying by 100 then dividing by 100? e.g .

 

ROUND(
({Settlement Amount} - Deductible - {Existing Claim ACV} - {JPA Fee for Settlement Email} - {Shingle Sample Company Cost} - {Tarp Fee} - {Umpire Fee}) * 100
) / 100

Marvel_digitals
4 - Data Explorer
4 - Data Explorer

You can fix this by wrapping your existing formula inside the ROUND() function to ensure it rounds to two decimal places. Then, use & "$" to add a dollar sign and TEXT() to format with commas. Try this:

"$" & ROUND(YourFormula, 2)
Or, for comma formatting:
"$" & TEXT(ROUND(YourFormula, 2), "#,##0.00")

This will round the amount correctly, add the dollar sign, and include commas. If you need help applying it to your specific formula, let me know! 😊