The following table describes the expected results when using the Variance function with Accounts.
Table 53. Expected Results when Using the Variance Function
Column A | Column B | Var ([A] , [B])=0 | Var ([A] , [B])>0 | Var ([A] , [B])<0 |
---|---|---|---|---|
Asset | Asset | 0 | Returns a positive value | Returns a negative value |
Liability | Liability | 0 | Returns a positive value | Returns a negative value |
Equity | Equity | 0 | Returns a positive value | Returns a negative value |
Revenue | Revenue | 0 | Returns a positive value | Returns a negative value |
Expense | Expense | 0 | Returns a negative value | Returns a positive value |