I have a report that has budget, total spent then remaining for ea project.
Then sum up the variances for all projects for the year. With me so far?
Budget - Expenses = balance
Ex: $100,000 $1000 $90,000
However if the project has no expense it leaves the variance blank and not carry over the budget which makes the report inaccurate.
Ex: $100,000 $0.00 Blank
I still need the budget to carry over if there is no expense. I have the expense as default and am forced to keep adding one records to make sure it appears. I'm sure there is an automatic way I'm missing.
Can u assist?