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.