4 Replies Latest reply on Jan 5, 2019 4:54 PM by Shahzad Bashir

    Existing staff calculation Firmwide minus New hires

    Shahzad Bashir

      I am trying to calculate impact of Existing staff calculation on billability. Formula is Total Firmwide hours minus new hires hours. Firmwide staff includes the all staff plus the new hires in a given month, so subtracting them will give me Existing Staff.

       

      attached please find my excel/tableau file.

       

      Solutions should look like this