Expected Results Using Planning Details

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

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