Expected Results Using Oracle Essbase
The following table describes the expected results when using the VariancePercent function with Oracle Essbase Accounts type members tagged as Expense or Non Expense.
Table 46. Expected results when using the VariancePercent function
Col A | Col B | VarPer ([A] , [B])=0 | VarPer([A] , [B])>0 | VarPer ([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 |