Expected Results Using Planning Details

The following table describes the expected results when using the Variance function with Planning Details Accounts tagged with the below UDAs.

Table 44. 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 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