The count of new hires who left the organization within 100 (or 200) days of start. The date can be adjusted based on business need and is common to determine turnover using a percentage. Keep in mind the measurements should be conducted within a certain period of time, and explained as such. Step 1 and Step 2 should include the number of employees that reflect the same time interval.
Step 1 |IF([HRIS.Employee.Termination_Date] <> AND(DATEDIFF([HRIS.Employee.Termination_Date] – [ATS.Candidate.Start_Date])<100) = 1, ELSE 0)
Step 2 | SUM([HRIS.Employee.100Day_Turnover_Binary]) / CNT([HRIS.Employee.Start_Date])