6 Replies Latest reply: Jul 28, 2016 8:07 AM by Phil Speight RSS

    Totals based on Min & Max

    Phil Speight

      Hi

       

      I have a table (below), and I want to calculate the turnover of staff using the Min & Max Month.  I have highlighted the data I need to show as a summary

       

          

      Start_MonthStaff in post at start of MonthStaff in post at end of MonthAvg Month Staff CountSum(Leavers)
      01/01/2015181918.51
      01/02/2015191818.50
      01/03/2015181918.50
      01/04/20151917181
      01/05/20151717170
      01/06/20151715160
      01/07/20151517160
      01/08/20151717170
      01/09/20151820190
      01/10/2015202321.51
      01/11/2015222121.50
      01/12/2015212221.50

       

       

      I want to show the following as a table.  How do I do it ?

       

          

      Staff in post at start of MonthStaff in post at end of MonthAvg Month Staff CountMin_MonthMax_MonthLeaversTurnover (Leavers/Avg Month Staff Count)
      18222001/01/201501/12/2015315%

       

       

       

      Any help appreciated?

       

       

      Regards

       

       

       

      Phil