6 Replies Latest reply on Jan 14, 2014 6:06 AM by adil sermouh

    How to perform avg by specific key

    Ling Li

      Hi, I have the following data:

      Job_NameTime
      A10
      A12
      B40

       

      I want to calucate the averge grouped by job_name, so I create the following CalculatedField:

      Sum([Time])/count([Job_Name])

      However if I then display the column totals I get the following:

      Job_NameTime
      A11
      B40
      Total20.67

       

      However I am expecting a total of: 51. How can this be achieved?


      Many thanks in advance.