...
You may be asking yourself - well why doesn't Projector just return zero or blank instead of a really big number? Great question!
Zero Budget
We have a reason for this. A zero budget is a real thing. You may have a zero budget for costs or a zero budget on billable amount for time. If we just turned 'infinity' into 'zero' you wouldn't be getting your real budget picture. The zeroes make it look like you are move over budget than you really are. By setting the value
Blank Budget
Unfortunately Excel treats blank pretty much the same as zero, so you have the same issues.
Infinite Budget
By setting an unset budget to a large number, we make these stand out so that you can reorganize your report in away that roll ups make sense.deal with them. And it works, because you are here reading this!
What can I do?
So now you know why it happens, what do you do? There are a couple few approaches here:
Filters
You can edit your report and go to the filters tab. From there, add the budget as a field and create a cut off at a big number.
...