Help

Actuel Rounding results with to many Zeros

Topic Labels: Formulas
Solved
Jump to Solution
845 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Abraham_Bochner
8 - Airtable Astronomer
8 - Airtable Astronomer

This is my data, inclusive of images, and the ensuing results I'm obtaining from Airtable on Make.com are clearly visible.

However, there seems to be a slight issue. Instead of receiving the value 1014.40 as expected, I'm getting 1014.4000000000001.

Could you guide me on how to rectify this discrepancy?

Abraham_Bochner_0-1686585152805.png

 

Abraham_Bochner_3-1686585216307.png

 

Abraham_Bochner_4-1686585220223.png

 

 

 

 

1 Solution

Accepted Solutions
Stephen_Orr1
10 - Mercury
10 - Mercury

Try changing your roll up aggregation formula to include everything in the existing round() or wrap what you have in another round(),  depending on your needs. Change the decimal precision in the field formatting settings to see what actual value is being returned vs. displayed in Airtable. 

See Solution in Thread

2 Replies 2
Stephen_Orr1
10 - Mercury
10 - Mercury

Try changing your roll up aggregation formula to include everything in the existing round() or wrap what you have in another round(),  depending on your needs. Change the decimal precision in the field formatting settings to see what actual value is being returned vs. displayed in Airtable. 

Abraham_Bochner
8 - Airtable Astronomer
8 - Airtable Astronomer

Yes I did the another rounding with Open AI GPT help - Thanks for your answer

Abraham_Bochner_0-1686673666901.png