cancel
Showing results for 
Search instead for 
Did you mean: 

Attrition Rate calculation in story reports

Arpit1
Newcomer
0 Kudos

Hello Experts,

We have a requirement to calculate the attrition rate, can you please help me that how we will calculate Attrition rate in story reports.

Thanks,

Arpit

Accepted Solutions (0)

Answers (1)

Answers (1)

Paul_Allen
Participant
0 Kudos

Hi,

You'll need to create a couple of calculations.

Calculation 1 = if Termination Date is between (the period you want the attrition to be based on) - This forms the No. Of Employee That Left During the Period

Calculation 2 = COUNT of: All 'Active Employees as of the START of the period above

Calculation 3 = COUNT of All 'Active Employees as of the END of the period above

Calculation 4 = The answer to (Calc 2 + Calc 3 above) divided by 2 - this forms the Average Number of Employee of Period

Then you just do the below: as a calculation in the story