@FreelanceReinh Thanks. So in the _s =2100, the logic is that the individual filled the form (event2) within 30days before they filled form(event1) after 30days. The forms are Mutually Exclusive. So if they are 2100, they should be counted at event2 only for the 0-30 day window. Another example is (If Case32=2, Event1= 2, Event2=2 and Event46C=1), this means they should be counted in the Event46C only for (0-30 days) because they filled form (Event46C) within the first 30 days. Other combinations where the form is mischaracterize and/or the time window are 2201, 2100,0012,0212,0221, 2221, 0102 etc (anything with one 1 and one or more 2s). I would like these individuals to be counted in the events or cases ONLY for the days window which they match (1=0-30days, 2=31-60days) because they filled atleast one form (events or case) in the first 30 days or 31-60 days. Those who will be in the multiple group will be for example when the events or cases have only the same value e.g., 0011, 0022, 2222,2200, 1110, 1111, 1010 etc.
... View more