Count if only null. ?

[suvechha_b]

Hi All,

How can I count distinct Policy number if both Policy Holder ID Number is null and Company_Registration_number is null. If any one is present then don't count.

I need to count the Policy Number even it is said 'Not Supplied'. sample model attached.

[sunny_talwar]

I think in the sample attached, both POLICY_HOLDER_ID_NUMBER and COMPANY_REGISTRATION_NUMBER are always null... but try this

Count(DISTINCT {<[Policy Number] = {"=Len(Trim(POLICY_HOLDER_ID_NUMBER)) = 0 and Len(Trim(COMPANY_REGISTRATION_NUMBER)) = 0"}>} [Policy Number])