6 Replies Latest reply: Jun 14, 2013 6:02 AM by maartenvdb RSS

    My expression keeps returning null



      I am stuck trying to get an average satisfaction code (rating 1 to 5) taken from the salesperson that sold the order for each type of return reason codes.


      I am using return reason code as dimension.

      I managed to get the total count of the return reasons with the expression: count(RETURN_return_code)


      The line I am trying to use to get the average satisfaction code per return reason code is:

      sum(SATISFACTION_TYPE_code) / count(RETURN_return_code)


      I also tried with avg(SATISFACTION_TYPE_code), but all I'm getting back is null values.


      Thanks in advance, I can also add a file if neccesary