Hey guys - I’m calculating attrition for my company at the moment. I know that we basically have to divide number of people in the team by number of people who resigned in a particular time period. I also know that people who are let go or laid off don’t have to be factored into this number. However I’m struggling to understand how to calculate attrition without including people who were let go in the opening number to ensure they’re also not accounted for the closing number. If any of you have dealt with something similar, possible to help here? Thank you!

I don't think you need to omit involuntary attrition. In fact it's another data point for you to calculate voluntary vs involuntary attrition. If you follow what you're saying you'll have to completely neglect the laid off folks as employees at all. You won't count them in any data which will not lead to true results, I feel. Also you need to divide the attrition count by the average of total count at the beginning and at the end of the considered time period. Feel free to correct me if I am wrong.

I wonder what Keka uses / can we check? @Megha

Yes, I will check this on Keka and revert back

Thanks for the help, guys! 🙂

Hey Richa, yes agree with what others have replied, but I highly suggest you build or integrate a software to have all this automated. Also a number doesn't say anything by itself. For ex, 30% attrition. Why? Who? When?

Thanks much 🙂