Expected Results Using Financial Management
The following table describes the expected results when using the VariancePercent function with Financial Management Accounts listed below.
Table 48. Expected results when using the VariancePercent function
Col A | Col B | VarPer ([A] , [B])=0 | VarPer ([A] , [B])>0 | VarPer ([A] , [B])<0 |
|---|
Asset | Asset | 0 | Returns a positive value | Returns a negative value |
Liability | Liability | 0 | Returns a negative value | Returns a positive value |
Income | Income | 0 | Returns a positive value | Returns a negative value |
Expense | Expense | 0 | Returns a negative value | Returns a positive value |
Flow | Flow | 0 | Returns a positive value | Returns a negative value |
Balance | Balance | 0 | Returns a positive value | Returns a negative value |
Balance Recurring | Balance Recurring | 0 | Returns a positive value | Returns a negative value |