How to deal with non existing data?

[Anonymous]

Hi Community,

The data keeps record of the customer statuses within the course of 12 weeks.

I am asked to create a new status called "Still Selected" that will ideally tell us whether there has been a status for a particular week.

For example, accountno 9626665 has 2 records for week 6 and the other one week 9. So, for weeks 1, 2, 3, 4,5,7,8,10, and 11 there has been no primary status, therefor no records. The goal is to create a new status Still Selected which will be 1 when there is no status in a week and 0 when at least one status exist in that week.

The challenge is I don't know how to set a condition to assess whether there is any status for each week when there is no records for some of the weeks!

Thanks,

[Anil_Babu_Samineni]

PFA