Skip to main content

Why am I getting a -0 result for this formula?

  • May 23, 2021
  • 2 replies
  • 38 views
Burner
Forum|alt.badge.img+15

Hi,

I created an “adjuster value” column to tweak the amount of stock to bring it to what I need it to be as different types of consumption columns are subtracting from it. For this particular record, when I tried to use a negative number in the ‘adjuster column’ to bring the available qty to zero, I get a negative zero?!?

Either this is a bug in Airtable or there’s something wrong with my formula.

My formula is simply

Produced - A - B - Adjuster Value = Available

Any help is much appreciated.

Thanks.

2 replies

R
Forum|alt.badge.img+4
  • Rose_K
  • Inspiring
  • May 25, 2021

Hello @Burner!

I just double checked your setup using all numbers fields and the formula returns as expected:

So I’m not sure why exactly this is happening, but it might be worth it to double check that the type returned for both your lookup and rollup fields are formatted as an integer:

If that doesn’t work I’d recommend contacting customer support here, because this might be a bug. Sorry for the frustration here and let me know if I can help with anything else!

JonathanBowen
Forum|alt.badge.img+18

Hello @Burner!

I just double checked your setup using all numbers fields and the formula returns as expected:

So I’m not sure why exactly this is happening, but it might be worth it to double check that the type returned for both your lookup and rollup fields are formatted as an integer:

If that doesn’t work I’d recommend contacting customer support here, because this might be a bug. Sorry for the frustration here and let me know if I can help with anything else!


@Burner - my guess here is that one of your numbers has some fractional part to it that isn’t displayed in the UI, so they all look like integers but one of them isn’t, giving rise to a negative number, e.g.:

-0.0034564

which is then displayed as:

-0

It could be a correct calculation of your underlying data or it could be a bug somewhere

kuovonne
Terms & ConditionsAccessibility statement