[AT_INTERNAL_GRADE] - At Internal Grade

22-Aug-2022 · Felix Fung

What is this?

A Yes/No question variable.

Check Whether the Placement is assigned to a certain Internal Grade. Internal Grade Code would be used in the formula.

What will the Value be Returned?

Y - if the Placement is configured to be the specified Internal Grade within the Pay Period.

N - if the Placement has no Internal Grade defined, or not the Internal Grade specified within the Pay Period.


Hightlight part content can be changed

1. Basic Form

Check single Internal Grade.

If the condition is correct, return the 1st value. Otherwise, returns the 2nd value.

Payroll Variable Description Usage
[AT_INTERNAL_GRADE](Internal Grade Code)] Check whether the Placement is assigned to a certain Internal Grade Only staff is with Internal Grade G8 would be entitled HKD 1,00 Bonus
IIF ('[AT_INTERNAL_GRADE(G8)]'='Y', 1000,0)

Except staff under Internal Grade G8, all the staff would be entitled HKD 1,000 Bouns

2. Parameters/Variations

Parameters/Variations Description Usage
| Check Multiple Internal Grades [AT_INTERNAL_GRADE(G8|Manager|Director)]