# Re: Formula field set to currency with 2 decimal places but getting up to 14 in token

Solved
417 0
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

I'm experiencing something weird - I have a formula field ("Cheque 2 amount") set up to subtract different currency fields. All fields, including Cheque 2 amount are set to currency format with 2 decimal places.

Everything looks normal in Airtable:

However, I have a "send email" automation set up that uses the Cheque 2 Amount as a token, and some of those emails are displaying this token with 14 or so extra decimal places (here is the email generated from that same record above):

Seems to be happening to maybe a quarter of the 160 or so records I was working with this morning.

I can't see anything different about the ones that are experiencing this glitch. My best guess is it has something to do with the Cheque 1 Amount field, which is a formula that calculates a percentage (SUM(.75*{Approved budget})) - however it is also set to currency format with 2 decimal places, along with all the other fields.

Anyone have any ideas???

1 Solution

Accepted Solutions
9 - Sun

Setting the format to 2 decimal places only changes what you see, the underlying amount remains the same.

Try ROUND((SUM(.75*{Approved budget}))*100)/100

If that is the only number causing the issue it should work.

3 Replies 3
18 - Pluto

Try creating a formula field with `ROUND()` to round your value to 2 decimal places and using that formula field's output in your email instead

Should be related to this: https://community.airtable.com/t5/formulas/floating-point-error-addition-subtraction/td-p/119000

9 - Sun

Setting the format to 2 decimal places only changes what you see, the underlying amount remains the same.

Try ROUND((SUM(.75*{Approved budget}))*100)/100

If that is the only number causing the issue it should work.

5 - Automation Enthusiast

Thanks! I actually ended up putting the ROUND formula within the Cheque 2 amount field and that seems to work!

IF(
{Over/Under} > 0,
ROUND(SUM({Approved budget} - {Cheque 1 Amount} - {Over/Under}), 2),
ROUND(SUM({Approved budget} - {Cheque 1 Amount}), 2)
)