Skip to main content

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???

 

 

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

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.

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)
)

Reply


Terms & Conditions