I want to calculate the attrition using the formula:
No. of exits in the current year / Avg. headcount of previous year
I calculated the avg headcount of 2023 using window avg. Now I want to use this as fixed value for denominator. The numerator will be count of exit Emp ID from 2024.
3 answers
@Akshara Athirala - For what it's worth, I would recommend matching the periods involved in both parts of your attrition rate. For example:
- No. of exits in the current year / Avg. headcount of current year
- No. of exits in the previous year / Avg. headcount of previous year
