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