Why does Formulae calculate Minus Zero?

I used a simple formula for column C (it is A-B), it shows up as -0 in one case and 0 for another? Why should zero have a negative sign?

In my case although all 3 columns are setup to round to 2 digits, I am certain that there is no third decimal digit in either column A or B.

Reason for asking is that it messes my colour codes where I’ve setup anything less than zero as red.

Even though you are rounding the display of A and B in their fields, Airtable still holds the full float in the background - down to the greatest level of specificity the float originally went to.

For better or for worse (probably for better), when you perform calculations via formulas on a number field that you have rounded in the display, the formula acts on the float behind the display, not the displayed/rounded version.

So, in your (A - B) formula, try rounding the end result of the calculation like this: ROUND(A - B).

If that still displays a negative 0, try rounding each number involved in the calculation like this: ROUND(A) - ROUND(B).

3 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.