Set analysis on all given value

[Anonymous]

Let say I have a table with 3 fields: Subject , Name , Grade

I want to test if in any given subject the average is above 60 – so just want to see Yes or No for that test – do not need a list of all subjects.

How will you recommend doing it elegantly? set analysis?

[Anonymous]

Error: Error in expression: Sum takes 1 parameter

[sunny_talwar · Accepted solution]

My bad, try this

If(Sum(Aggr(If(Avg(Grade) > 60, 1), Subject)) >= 1, 'Yes', 'No')

[Anonymous]

so beautiful, many thanks