2 Replies Latest reply: Sep 19, 2013 10:58 AM by Thomas Jensen RSS

    Calculate AVG

      Hello,

       

      I am trying to calculate average, but the value is too low.

       

      I have a Total of 710 with 16 unique dates.

       

      When i do AVG(TotalAmount) it gives me 22. but it should be 44.

       

      Ive tried to read this blog http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/29/averages

       

      but when i do =Avg( Aggr( Sum(TotalAmount), MonthYear ) ) it gives me the sum on 710.