I do apologize if this has been asked before. I tried to look around but didn’t see anything. I am new to Tiller. I’m pretty good with spreadsheets, though I’ve never really done stuff with tables before so I’m a little unsure of the best way to double check what the formulas are doing. The issue I am having is that when I put a value in the Categories spreadsheet’s budget columns that matches what I spent that month, it’s not creating a true 0. Instead, the value shows up as a red 0 in the Monthly Budget tab. That wouldn’t be too bad an issue, but I’ve also added a new tab for myself for “envelopes”. It pulls the data from the monthly budget and then I do a simple bar graph to the right to show how much I have left to spend for the period. Anyway, as you can see, it shows a very small number for the difference and not zero. Not sure why this would be as I’ve even expanded the numbers out many places to ensure that there isn’t a slight difference in the numbers somehow? Anyway, not really expecting much but just putting this out there in case someone else has seen this kind of thing and has a solution. Thanks!
This system will only let me put one screenshot in. Just know that this pulls directly from the Monthly Budget tab, where the “zero” value is red, but does show “0.00” on that tab.
I believe this is a generally known floating point error type issue that can occur sometimes.
One option is to use ROUND() to avoid it.
1 Like
I’ll try that, thanks!
Let us know how it goes @mbci !
Yeah I just add =ROUND(blah blah of the original formula, 1) so that it rounds to the next whole number. Seems to work like a charm.
1 Like