cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP Analytics Cloud - Duration calculation Between Two Dates

shiva1233
Explorer
0 Likes
56

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.

ChatGPT Image.png

Accepted Solutions (0)

Answers (0)