I have a table of categories that are counted by month. Starting with the last month in the table, I need to count the number of consecutive months each category has a count of "0".
Think of it as # of consecutive months each department has 0 injuries. If we have 0 injuries in Dec-13, Nov-13, Oct-13, the count would be 3. If there were no injuries in Dec 13, 1 in November 13, and 0 in October, the count would be 1.
Anybody lead me in the right direction I'd appreciate it. Thanks.
Think of it as # of consecutive months each department has 0 injuries. If we have 0 injuries in Dec-13, Nov-13, Oct-13, the count would be 3. If there were no injuries in Dec 13, 1 in November 13, and 0 in October, the count would be 1.
Anybody lead me in the right direction I'd appreciate it. Thanks.
