Forum Discussion
Filter with multiple conditions
Hi, I have a listing of employees salary payments for 2022. I only want to filter employees who have been paid contract gratuity in the corresponing period, including all other allowance fields. An ...
please indicate the expected outcome based on the sample data you provided.
this is my expected outcome:
| EMPLOYEE_NUMBER | PAYROLL_CLASS | PAY_YEAR | CYCLE_NO. | CLASSIFICATION_NAME | ELEMENT_NAME | PAY_VALUE |
| 109500 | Calendar Month | 2022 | 1 | Earnings | Basic Salary Monthly | 22848 |
| 109500 | Calendar Month | 2022 | 1 | Earnings | CONTRACT GRATUITY 066 | 82252.8 |