This page (revision-3) was last changed on 26-Nov-2021 10:22 by JEscott

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
3 26-Nov-2021 10:22 1 KB JEscott to previous
2 26-Nov-2021 10:22 901 bytes JEscott to previous | to last
1 26-Nov-2021 10:22 81 bytes JMyers to last

Page References

Incoming links Outgoing links
ASSUMPTION_WHERE
ASSUMPTION_WHERE

Version management

Difference between version and

At line 1 changed one line
ASSUMPTION_WHERE is an optional 2000-character alphanumeric field.
ASSUMPTION_WHERE is an optional 2000-character alphanumeric field which allows users to limit the formula to the statement in the ‘where’ clause.
At line 3 changed one line
[CLEANUP]
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
This page (revision-3) was last changed on 26-Nov-2021 10:22 by JEscottTop