Expected Results Using Financial Management

The following table describes the expected results when using the Variance function with Financial Management Accounts listed below.

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

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