Grouping

[tracycrown]

Dear sir / madam

Can someone help me to resolve the issue on Grade which is missing in table 2 attached ?.

Thank you

Tracy

[sunny_talwar · Accepted solution]

Try this:

Aggr(If(Sum(Score) >= [Lower Score] and Sum(Score) <= [Upper Score], Grade), Code, Grade)

[maxgro]

A script solution in the attachment