Forum Discussion

LeahGJ's avatar
LeahGJ
Frequent Visitor
4 years ago

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 ...
Need Help
LeahGJ's avatar
LeahGJ
Frequent Visitor
4 years ago

Thanks Ibendlin. can you share a meaure for this calculated column please. 

lbendlin's avatar
lbendlin
Super User
4 years ago

please indicate the expected outcome based on the sample data you provided.

  • LeahGJ's avatar
    LeahGJ
    Frequent Visitor
    4 years ago

    this is my expected outcome:

     

    EMPLOYEE_NUMBERPAYROLL_CLASSPAY_YEARCYCLE_NO.CLASSIFICATION_NAMEELEMENT_NAMEPAY_VALUE
    109500 Calendar Month20221EarningsBasic Salary Monthly22848
    109500 Calendar Month20221EarningsCONTRACT GRATUITY 06682252.8