The following table describes the expected results when using the VariancePercent function with Accounts tagged with the below UDAs.
Table 54. Expected Results when Using the VariancePercent Function
Col A | Col B | VarPer ([A] , [B])=0 | VarPer ([A] , [B])>0 | VaPer ([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 |
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 |