Skip to Content
0
May 18, 2020 at 12:11 AM

Nested IF condition SAC

409 Views

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.