Skip to main content
Solved

Actuel Rounding results with to many Zeros


Forum|alt.badge.img+17

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?

 

 

 

 

 

 

Best answer by Stephen_Orr1

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. 

View original
This topic has been closed for replies.

2 replies

Forum|alt.badge.img+18

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. 


Forum|alt.badge.img+17

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