8 Replies Latest reply: Jun 20, 2014 4:43 AM by Dennis Bijman RSS

    Avg function not working as expected

      Hi everyone,

       

      I have some problems with my expression with the Avg funtion in it.

      My formula is: Avg(Aggr([1],[2],[3],[4],[5],[6],[7],[8],[9],[10]))

      And it shows an output value but it's not correctly.

      I have also some statistic objects which calculates the average of a column and I think that's working fine but in my KPI it's not.

      When using a calculator and calculate the average of the statistic object I have another output then my KPI is showing.

      Please see the attachment to clear some things up.

      The 3 KPI's have all 3 groups of columns(answers) you can see on the right side.

       

      Please ask me if you need further info or another screenshot, thanks a lot!