4 Replies Latest reply on Aug 9, 2016 1:52 PM by Jeffrey Canham

    Average Income with shifting number of employees

    Jeffrey Canham

      Hey everyone,

       

      I'm fairly new to the software and am having some difficulty figuring out how to get the information that I'm trying to hunt down. Hopefully I'm in the right place to ask this question!

       

      Ideally I'd like to come up with a sheet that tells me:

      a) The commission that various sales people brought in each year

      b) The average amount of commission only certain employees brought in each year

       

      This would be pretty simple if it was just the average of all employees and the number of employees stayed static, but we've had people come and go. I'm interested in a specific 14 (new employees), but each year has a different number of sales people due to the shifting number of employees. Theoretically it would be: Sum(Commission)/Number of Records of the specified employees, but only if they have a record in that year.

       

      Any ideas on the best way to approach this?

       

      Thanks in advance!