Skip to main content
Solved

Actuel Rounding results with to many Zeros

  • June 12, 2023
  • 2 replies
  • 25 views

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. 

2 replies

Forum|alt.badge.img+18
  • Inspiring
  • Answer
  • June 12, 2023

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
  • Author
  • Known Participant
  • June 13, 2023

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