I have multiple tables that deal with budgeting, and in each one I've got a similar setup. I track the total budgeted and then how much we've spent manually, then a formula determines the difference and another formula looks at that difference and determines the status of the budget. It works great 95% of the time and looks like the below.
| Total Budgeted | Total Spent | Difference | Status |
| $100,000 | $100,000 | $0 | Matches Budget |
| $500,000 | $650,000 | -$150,000 | Over Budget |
| $300,000 | $200,000 | $100,000 | Under Budget |
The problem I'm seeing is that every once in a while I will get a record where the Difference correctly shows $0, but instead of Matches Budget the formula will return Under Budget or Over Budget. I don't know what could be causing this since there's no rounding taking effect; it's all precise numbers and formatted as currency.
The formula I use to determine the Difference result is {Total Budgeted}-{Total Spent} and in the screenshot below you can see three different records, all with zero amounts for the difference, yet each giving a different status. The first is a negative zero amount which makes no sense to me.
The formula for the Status is below. It's basic math and yet Airtable occasionally seems to get confused and give unexpected results.
IF(
{Difference} > 0,
"Under Budget",
IF(
{Difference} < 0,
"Over Budget",
"Matches Budget"
)
)Any ideas as to what might be causing this? I'm at a loss and it's making it difficult to rely on the Status since it isn't always right.