Hi!
I want to calculate the employee attrition rate with the data I have. Two columns in my data are important for this: the joining date, and Employee status.
For example if I have to calculate attrition rate for the period of Jan 1st 2020 to April 30th 2020, the Attrition rate is calculated by: Number of employees active between Jan 1st 2020 to April 30th 2020/(Number of employees active before jan 1st 2020 + number of employees active before April 30th 2020)/2
Can someone help me calculate this? I am not not able to create this formula in SAC.