This is version 1 2 3 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

ASSUMPTION_WHERE is an optional 2000-character alphanumeric field which allows users to limit the formula to the statement in the ‘where’ clause.

For example, if you wish to increase the wage rate of all in Unit of AMW by 2.5%, the statement would be, ‘Let the wage rate be equal the wage rate times 1.025 where the employee’s Unit is AMW’.

Therefore, the formula for the assumption would be:

Wage_Rate = Wage_Rate * 1.025

The ‘Where’ clause would be:

Group_Code = ‘FULL-TIME’

Formula Rules

All CHAR or alphanumeric information must be entered with single quotes around them.

Standard formula format is A = B + C not B + C = A, as with UserCalcs.

Formula: WAGE_RATE = WAGE_RATE * 1.02

Formula:PREMIUM_CODE = 'UNIFORM'

Where:UNIT = 'alphanumeric'

Where: WAGE_RATE > 12.25

Where: VACANT not filled positions

Where:NOT VACANT only filled positions