Wrong Average Computation

[tracycrown]

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]

Hi @tracycrown 

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]

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