11 Replies Latest reply: Mar 23, 2016 12:23 PM by Stefan Wühl RSS

    What I am doing wrong do get a correct Average and Median in QV?

    Nenad Vuković

      Hi,

      I hope someone can help me out here. I do not get correct Average and Median numbers for a simple case of two prices in 8 rows.

       

      For example:

      Date          Price

      04.01.2016 70.88

      14.01.2016 70.88

      20.01.2016 70.88

      21.01.2016 70.88

      08.02.2016 68.60

      22.02.2016 68.60

      07.03.2016 68.60

      14.03.2016 68.60


      and I get an Average of 69.67 and Median of 68.60 instead of 69.74 for both.


      I use this expression to get the average: aggr(avg(Price), F1, F2)


      Thanks