cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PatrickLamoste Frequent Visitor
Frequent Visitor

Calculating Attrition Rate

Hello,

 

I hope you can help me.

 

I am trying to calculate the attrition rate of Employees. The formula that I have to use is:

Ave# of Employees = Beginning Headcount + Ending Headcount / 2

Attrition Rate (%) = Total# of Termination / Ave# of Employees * 100

 

And below is my dataset:

 

Personnel NumberEmployee NameEmployment Start DateLast Date Worked
0001Smith, John02/01/200830/11/2017
0002Smith, Jane15/08/201625/05/2017
0003Doe, John27/02/201701/03/2017
0004Doe, Jane22/03/201810/05/2018
0005Jackson, Mark05/06/201809/10/2018
0006Jackson, Mich09/07/201820/09/2018
0012Johnson, Kelly23/07/201829/11/2018
0013Johnson, Jessica14/11/201631/08/2018
0014 10/05/201504/03/2017
0015 14/03/201129/03/2018
0016 29/11/2018 
0017 05/12/2018 
0018 19/09/2016 
0019 07/12/2018 
0020 07/01/2019 
0021 09/01/2019 
2 REPLIES 2
Community Support Team
Community Support Team

Re: Calculating Attrition Rate

Hi @PatrickLamoste,

 

I have a little confused about your scenario.


I am trying to calculate the attrition rate of Employees. The formula that I have to use is:

Ave# of Employees = Beginning Headcount + Ending Headcount / 2

Attrition Rate (%) = Total# of Termination / Ave# of Employees * 100

 

What is the Beginning Headcount, the ending Head count and the Total# of Termination?

 

If it is convenient, could you share your desired output based on the data sample you shared so that I can understand your scenario better and get the solution quickly.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PatrickLamoste Frequent Visitor
Frequent Visitor

Re: Calculating Attrition Rate

The beginning headcount is the number of employees for my case it's April 1 as it is our FY start date. The end headcount is the total number of employees left at the end of the period March 31. Get their sum and then get the average.

 

Termination is the number of employees who left the organization.

 

FInally, divide the number of termination with the average employees to get the attrition rate.

 

The output that I need is to get the attrition rate either monthly or annually.

 

Let me know if you need more information.

 

Thank you!