Financial Reporting Divided by zero or negative
Hello there,
I'm building a simple budget variance report and is having a hard time getting the formulas right for $Variance and %Variance.
A little bit background:
Column A is Actual, Column B is Budget, Column C is $Variance (Actual - Budget), Column D is %Variance (Actual-Budget)/Budget
On the grid level, I have set #missing (no data) to 0, which I think causes problem later on in the $Variance and %Variance calculation.
I also set column C's formula to be [A]-[B].ifNonnumber(0), to avoid any #error. So far $VAriance column is calculating correctly.
The hard time I'm having with is the %Variance formula