Filter not working for case statement
I am creating a HDL formatted report to produce a list of employees that require termination from HCM.
I have managed to produce a list of all the employees that match this requirement, but also I am picking up records that just need an assignment ending and not terminating.
I have tried filtering on the result produced but the data is still output in the report.
Content (please ensure you mask any confidential information):
Create a report that will pick up all active employees that have a specific user person type (in this case External Examiner) and count all of the assignments this employee has.