7 Replies Latest reply: Mar 20, 2014 6:20 PM by Angel Moya RSS

    Aggregation issue

      Hello all,

       

      I have a problem with a report I am creating where I need to put all information regarding the people involved in exams, the report should be able to show average score of the person who is being evaluated but also the average of the team this person belong to and also the whole universe within same exams this person has been involved in.

       

      the function I use to get average score is: SUM( RES_VALUE) / (SUM(QST_VALUE) * COUNT(DISTINCT COD_USR))

       

      All your help is very valuable

      Thanks