What is this:
Whether the placement is assigned to a certain department..
Value will be returned:
Y - if the placement belongs to a particular department by the end of the payroll period.
N - if the placement not belongs to the specified department by the end of the payroll period
Company want to give $1000 allowance to staff within the Sales department. When this can be done by assigning different pay rates to staff profile, you can also let Backstage conditionally issue the allowance by this formula:
IIF ('[IN_DEPARTMENT(SALES)]'='Y', 1000,0)
It will return "Y" if the staff is in SALES department by the end of the payroll period.
You can also use | to check for multiple departments. For example,