Find average where variables are defined

[Anonymous]

Hello

I am looking to find the average of a field where two other fields are defined

i.e.

Avg(A)({< = {'1'}, = {'2'}>} )

Find the average of A where B = 1 and C = 2

Thank you

[jonathandienst · Accepted solution]

Like this:

=Avg({<B = {1}, C = {2}>} A)