Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Rounding or Precision Issues

Topic Labels: Dates & Timezones Formulas
437 1
cancel
Showing results for 
Search instead for 
Did you mean: 
dorishuntt
4 - Data Explorer
4 - Data Explorer

If you're working with numbers and formulas are returning different results, rounding differences or precision errors could be the cause.

Solution:

Ensure that both formulas are using the same precision (number of decimal places).

Use the ROUND() function in Excel or SQL to limit precision.

1 Reply 1
Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @dorishuntt! The ROUND() formula will def work in Airtable! Do you have any specific question about it?

Mike, Consultant @ Automatic Nation