Case 932 How to make the count result = 3 ?

[paulyeo11]

Hi All

I have below table , it display 4 is wrong  , how to make it display 3 ? Enclosed ny QVW for your ref.

[tresesco]

Change the expression to:

count(distinct {<[E-Mail List]={"=Len(Trim([E-Mail List]))>0"}>} [E-Mail List])

[Kushal_Chawda · Accepted solution]

@paulyeo11  try below expression

count(distinct {<[E-Mail List]={"=len(trim([E-Mail List]))>0"}>}[E-Mail List])

[paulyeo11]

Thank you very much.