Kelli Webb
Member
Hi, sorry if this is a duplicate post from last night - I couldn't find it..
I would like some assistance to identify employees in the attached who has received an increase after the 1/7/2021 & if so, how much was it?
As per the example in columns E & F.
thank you for your time! Kelli
I would like some assistance to identify employees in the attached who has received an increase after the 1/7/2021 & if so, how much was it?
As per the example in columns E & F.
thank you for your time! Kelli
Employee Id | First Name | Effective Date | FTE Salary | YTD Increase | Increase Amount |
99478 | Employee 1 | 7/07/2020 | 166000 | No | |
99495 | Employee 2 | 1/07/2020 | 53000 | No | |
99497 | Employee 3 | 25/02/2020 | 194310 | No | |
99497 | Employee 3 | 1/07/2020 | 196000 | No | |
99501 | Employee 4 | 1/07/2020 | 60000 | No | |
99501 | Employee 4 | 12/09/2020 | 72170 | Yes | 12170 |
99507 | Employee 5 | 1/07/2020 | 239292 | No | |
99508 | Employee 6 | 1/07/2020 | 127000 | No | |
99511 | Employee 7 | 1/07/2020 | 140000 | No | |
99511 | Employee 7 | 10/10/2020 | 141000 | Yes | 1000 |
99532 | Employee 15 | 1/07/2019 | 71500 | No | |
99532 | Employee 15 | 12/09/2020 | 71500 | No | |
99532 | Employee 16 | 15/09/2020 | 72000 | Yes | 500 |