With if try this:
=Count(if(ACTIVE='YES' and type= 'PAF',customers,null())
With set analysis is the answer, that kaushik.solanki wrote. That expression should return the same with count+if.
Hi Gabor Tarnoczai,
Thanks for your response.
Count(if(ACTIVE='YES',customers)) this gives me -- 150 in the filter I've selected type (PAF).
If I use your expression
Count(if(ACTIVE='YES' and type= 'PAF',customers,null()) -- it gives more than 150 not even close