Average on Set Analysis

[#1]

Good day,

I want to get avg on set analysis.

I have 2 fields, score and status, now I want to calculate an average of score when the status = A on set analysis.

Much appreciated!

[swuehl · Accepted solution]

=Avg({<status = {'A'}>} score)