11 Replies Latest reply: Jun 16, 2017 6:57 AM by Phil Speight RSS

    SUM AGGR

    Phil Speight

      I just can't get my head around this AGRR()function, and I really need it.

       

      I want to Aggr a total based on the sum of the jobref.  Please see my data below:

       

         

       

         

      Job RefApplicant RefVacancy FTEVacancy StageVacancy State
      ABCD100010.8InterviewScheduled
      ABCD200010.8InterviewScheduled
      ABCD300010.8InterviewScheduled
      ABCD400010.8InterviewScheduled
      BCDE500011.0InterviewScheduled
      BCDE600011.0InterviewScheduled
      BCDE700011.0InterviewScheduled
      CDEF800012.0OutcomeSome Posts Filled
      CDEF900012.0OutcomeSome Posts Filled
      DEFG999991.4OutcomeAll Posts Filled
      DEFG888881.4OutcomeAll Posts Filled
      EFGH777770.5OutcomeAll Posts Filled
      EFGH666660.5OutcomeAll Posts Filled
      EFGH555550.5OutcomeAll Posts Filled
      FGHI444445.0ShortlistingShortlising
      FGHI333335.0ShortlistingShortlising
      FGHI222225.0ShortlistingShortlising
      GHIJ111111.0OfferOffer

       

      I want to show The Following :

       

        

      Expected Result
      Vacancy FTEStageState
      1.8InterviewScheduled
      2.0OutcomeSome Posts Filled
      1.9OutcomeAll Posts Filled
      5.0ShortlistingShortlisting
      1.0OfferOffer

       

       

      I know it's simple, I just keep getting it wrong though.

       

       

      Please help

       

       

      Cheers

       

       

       

      Phil