cancel
Showing results for
Did you mean:
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:

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
2 REPLIES 2
Community Support Team

## Re: Calculating Attrition Rate

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

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.
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.