Expected Results

Table 11-12 Expected Results When Using VariancePercent/VarPercent

Col A Col B VarPer ([A] , [B])=0 VarPer ([A] , [B])>0 VaPer ([A] , [B])<0
Expense Expense 0 Returns a negative value Returns a positive value
Non-Expense Non-Expense 0 Returns a positive value Returns a negative value