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.