Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below table , it display 4 is wrong , how to make it display 3 ? Enclosed ny QVW for your ref.
@paulyeo11 try below expression
count(distinct {<[E-Mail List]={"=len(trim([E-Mail List]))>0"}>}[E-Mail List])
Change the expression to:
count(distinct {<[E-Mail List]={"=Len(Trim([E-Mail List]))>0"}>} [E-Mail List])
@paulyeo11 try below expression
count(distinct {<[E-Mail List]={"=len(trim([E-Mail List]))>0"}>}[E-Mail List])