Dear all,
I just put criteria in that way (Attachment Query) to get value in OT28Days Column where if someone is equal to or more than 28 days he is eligible for 1200 if he accepted Yes (28DaysAccepted? Column) + OT (Lets say if he work for 30 days than 1200 + 2 OT) If Employee not (Not accepted 28 days) than I need to pay him Basic Earned + OverTime. My criteria are working nicely but I am facing one problem, if one staff (28days acceptance) works for only 27 days than I have to pay him BasicEarned + OverTime. Which I want to show Basic Earned + 1 OT but my criteria is showing blank for those staff you can see for IDNumber 100001.
Please advice if my criteria is wrong.
I just put criteria in that way (Attachment Query) to get value in OT28Days Column where if someone is equal to or more than 28 days he is eligible for 1200 if he accepted Yes (28DaysAccepted? Column) + OT (Lets say if he work for 30 days than 1200 + 2 OT) If Employee not (Not accepted 28 days) than I need to pay him Basic Earned + OverTime. My criteria are working nicely but I am facing one problem, if one staff (28days acceptance) works for only 27 days than I have to pay him BasicEarned + OverTime. Which I want to show Basic Earned + 1 OT but my criteria is showing blank for those staff you can see for IDNumber 100001.
Please advice if my criteria is wrong.
