Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
How to count distinct Policy Number if 'POLICY_HOLDER_EMAIL_ADDRESS' field is null.
Sample model attached.
May be this
Count(DISTINCT {<[Policy Number] = {"=Len(Trim(POLICY_HOLDER_EMAIL_ADDRESS)) = 0"}>} [Policy Number])