12 hours ago
I have employee event history data with multiple records for the event reason “Promotion - Annual Pay Change” for the same employee. I need to calculate the duration between the latest Start Date of the promotion event and the Last End date or till now. Since there are multiple promotion records, I want SAC to dynamically pick the most recent Start Date and calculate the duration.
Request clarification before answering.
| User | Count |
|---|---|
| 13 | |
| 8 | |
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.