How to calculate distinct count depending on 'POLICY_CANCELLATION_DATE_YearMn' on every month wise

[suvechha_b]

Hi All ,

How can I calculate policy cancelled for that particular UW_MONTH_KEY . I got a field POLICY_CANCELLATION_DATE_YearMn . How to do in set analysis to get the count of policies cancelled depending on UW_MONTH_KEY.

My expression is -

Count({$<UW_MONTH_KEY = {"$(=$(vMaxUWMonth))"},POLICY_STATUS_FINAL={'Cancelled'},POLICY_CANCELLATION_DATE_YearMn = {"$(=$(vMaxUWMonth))"}>} DISTINCT POLICY_NUMBER)

Sample model attached.

Please kindly assist.