A Yes/No question variable.
Check whether the Placement is assigned to a certain Department. Department Code would be used in the formula.
Y - if the Placement is under the specified Department by the end of the Pay Period.
N - if the Placement is not under the specified Department by the end of the Pay Period
Hightlight part content can be changed
Check single Department.
If the condition is correct, return the 1st value. Otherwise, returns the 2nd value.
Payroll Variable | Description | Usage |
---|---|---|
[IN_DEPARTMENT(Department Code)] |
Check whether the Placement is assigned to a certain Department | Only staff under HR&Admin Department would have HKD 1,000 allowanceIIF ('[IN_DEPARTMENT(HR&ADMIN)]'='Y', 1000,0) Staff not under Sales Department use 1,000 as pay rate. Only Sales Dapartment staff use Avervage Daily Wages as pay rate IIF ('[IN_DEPARTMENT(SALES)]'='N',1000,[ADW]) |
Parameters/Variations | Description | Usage |
---|---|---|
| | Check Multiple Departments | [IN_DEPARTMENT(SALES|IT|HR&ADMIN)] |