Variance Operators

Variance operators enable you to specify the precise range of variance that you want to report on.

For example, you want to determine the monthly car allowance paid to employees in excess of 600 more than the previous month for the same payroll relationship. You can setup a balance exception for this example using these values:

• Comparison type is previous month

• Balance name is monthly car allowance

• Dimension name is relationship month to date

• Previous month amount is 500

• Variance value is 100

This table describes the effect of using each of the variance operators for balance exception reporting. The Results column indicates the effect of selecting each variance operator.

Variance Operator	Balance Exception Report Output	Results (based on sample data)
Variance, plus or minus Note: This operator applies only for comparison types of 'Previous', like Previous Months or Previous Period, as well as 'Average in Months'.	All relationships whose balance value either exceeds or are less than the previous month amount by the amount or percentage stated in the variance value.	Returns all relationships with a value less than or equal to 400 and greater than or equal to 600.
Less than	All relationships that are less than the previous month amount by the amount or percentage stated in the variance value.	Returns all relationships with a value of less than 400.
Less than or equal	All relationships with a current value either equal to or less than the previous month amount by the amount or percentage stated in the variance value.	Returns all relationships with a value of 400 or less.
Equal	All values that are exactly equal to the higher limit or the lower limit of the variance value.	Returns all relationships with a current value equal to 400 or 600.
Greater than	All relationships that are greater than the previous month amount by the amount or percentage stated in the variance value.	Returns all relationships with a value of more than 600.
Greater than or equal	All relationships with a current value either equal to or greater than the previous month amount by the amount or percentage stated in the variance value.	Returns all relationships with a value of 600 or more.
Does not equal	All relationships with a current value not equal to the previous month amount.	Returns all relationships with a value other than 500.

Select a Balance Type and Balance Dimension that specifies the balance value that's evaluated for the exception. You can only select balance dimensions that are compatible with the Comparison Type you specified. For example, if the Comparison Type is Current Period, you can only select balance dimensions of type 'Period to Date'.