3 Replies Latest reply on Jun 21, 2013 11:13 AM by jaimie.stark

    Turnover calculation with two data sources

    jaimie.stark

      I'm trying to calculate a Monthly Turnover % by Department where Monthly Turnover % = (# terminations in month)/((month headcount + previous month headcount)/2).

       

      I have two Excel data sources: 1) 'Employee Log' with a list of all active employees by Report Effective Date and 2) 'Terms' containing a list of all terminations and related termination date. I created a sample similar to my dataset in the attached file.

       

      I successfully caclulated Average Monthly Headcount and Monthly Terms however when I link them I'm not getting the desired result. The issue appears to be related to the Date/Department combinations where count of terms is zero. I've included additional notes in the captions of my sample file.

       

      Any help would be very much appreciated!!