We have a requirement to calculate the attrition rate, can you please help me that how we will calculate Attrition rate in story reports.
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