Expected Results

The following table describes the expected results when using the Variance function with Accounts.

Table B-7 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