Help with Average condition

[ivandrago]

Hi, I want to average a field where it meets a condition? How would I write the expression for this?

Below is what I currently have for the field expression:

Avg(Sales)

What I want it changed to is that it will Average the Sales field if the flag is equal to 1

Avg(Sales) where Flag =1

Thanks

[johnw · Accepted solution]

avg({<Flag={1}>} Sales)