Calculating Attrition Rate

[PatrickLamoste]

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 Number	Employee Name	Employment Start Date	Last Date Worked
0001	Smith, John	02/01/2008	30/11/2017
0002	Smith, Jane	15/08/2016	25/05/2017
0003	Doe, John	27/02/2017	01/03/2017
0004	Doe, Jane	22/03/2018	10/05/2018
0005	Jackson, Mark	05/06/2018	09/10/2018
0006	Jackson, Mich	09/07/2018	20/09/2018
0012	Johnson, Kelly	23/07/2018	29/11/2018
0013	Johnson, Jessica	14/11/2016	31/08/2018
0014		10/05/2015	04/03/2017
0015		14/03/2011	29/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

[Ali087]

[JSanchin]

Any updates on how to calculate the attrition percentage?

[v-piga-msft]

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

[PatrickLamoste]

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!

[Ali087]

Please guide, how to calculate average number of employees in a spesific month ? 

i have calculater in my dashboard and all related data but im stuck in it.