2 Replies Latest reply on May 4, 2012 8:01 AM by kym.wong

    how to count strings

      Hello

       

      My data is as below:

       

      BA Name          Engagement Score

      AA                         20

      BB                         18

      CC                         22

      AA                           2

      CC                          8

      DD                          16

      AA                         12

      BB                         10

      BB                          10

       

      I need to calculate the average score of each BA e.g. AA would be 11.3, BB=12.6 etc.  Please note that Engagement Score is a calculated field.  It is an aggregation of scores from several data points to create this calculated value.  Ultimately, what I want to achieve is (total engagement score for a BA)/X where X is the total maximum score that any BA can accumulate.

       

      Thank you.

      Kym