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