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


Notes #

Click to create a new notes page