Total of all Averages

[tracycrown]

Dear all

Can someone advise me how to compute the total of all averages for last column in Table 1 ?.

The correct answer is shown in Table 2, Student A - 20, Student B - 16.

Thank you, Tracy

[MayilVahanan · Accepted solution]

Hi @tracycrown ,

Try like this

If(RowNo()=0 or IsNull(RowNo()),
Sum(Aggr(If(avg(Score)>= (Lower) and avg(Score) <= (Upper),Grade),Student, Subject, Lower, Upper)),
avg(Aggr(If(avg(Score)>= (Lower) and avg(Score) <= (Upper),Grade),Student, Subject, Term, Score, Lower, Upper)))

[tracycrown]

Dear Mr Mayilvahanan

Thank you do much for your quick response, you are very knowledgeable and helpful and I have learned something new from you. 

Best Regards, Tracy