topic Re: Wrong Average Computation in QlikView

Wrong Average Computation

tracycrown — Fri, 15 Nov 2024 23:39:03 GMT

Dear all

Can someone kindly advise why the average is computed wrongly, the correct answer should be :

Score 71.25 and Point 3.35

Thank you, Tracy

MayilVahanan — Wed, 11 Nov 2020 04:16:17 GMT

FYI, avg in the excel sheet also 70.8

In order to achieve the result, Try like this

If(Isnull(RowNo()), Avg(Aggr(avg(Score),Year,Class)), avg(Score))

tracycrown — Wed, 11 Nov 2020 08:47:45 GMT

Dear Mr MayilVahanan

Thank you so much for your QUICK response, I tried and both worked.

If I change the Point to computation mode under expression, please advise how to apply your method.

Also, kindly advise why NO Grade for Score 80.50 in Class A etc. and Average for Point (3.3) is WRONG ??

Thank you, Tracy