Expected Results Using Essbase

Table 10-6 Expected Results When Using VariancePercent with Essbase

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