Combining formulae

[#1]

Hi,

I would like to combine these two formulae.

1. Count({$<[Revenue]={">0"}>} [Student No])
2. if(Details='Hockey',[Hockey])

The formula in point 2. Should replace the [Revenue] in the formula in point 1.

Tried,

Count({$<if(Details='Hockey',[Hockey])={">0"}>} [Student No])

Any suggestions are welcome.

Thank you

[Gysbert_Wassenaar]

Not sure what you're trying to do. Perhaps this is what you're looking for:

Count({$<Details={'Hockey'},[Revenue]={">0"}>} [Student No])