how can i put if, then count in the one expression?

[Anonymous]

Hi ,

I want to achieve the following but am not having any luck.  Any help appreciated:-

I want to count(green) all accountNo. or lines where the Member = 'Yes', and the AccountNo and productClassifation are the same.

Count
4
AccountNo	AccountName	Member	ProductNumber	ProductClassification
2500	Red Sox	Yes	503650	RedBox
2500	Lost and Found	Yes	502144	Glass
2750	Blue Bears	No	502014	RedBike
2700	Green Toads	Yes	502260	RedDoor
2700	Green Toads	Yes	502874	RedDoor

I'm trying :-

=if(IsMember='Yes',count(DISTINCT[AccountNo]&[AccountName]&[ProductClassificationSummary]) )

[Saravanan_Desingh]

Hi Jagan,

Thanks for this information. I was not aware before that we can use LIKE in IF. I had many places of such, where I was using MATCH or WILDMATCH before.