Need to find a consecutive trend of negative numbers

[c-yun]

Hello,

I need help figuring out what tools I need to use to resolve the concept below. Could someone help, please?

I want to look at the past 5 weeks of net error (labeled "Net Error WK 5", "Net Error WK 4", etc) and create a column that will flag if there are 3 consecutive weeks of negatives.

I tried creating individual columns that will flag if it's a positive or negative number, but not sure how to aggregate this to one column to give me an ultimate flag of "yes or no there were 3 consecutive weeks of negative numbers".

(I'm aware I have a few errors throughout this workflow, I'm still trying to work through some of those as well)

[CSmith16]

The included .yxmd file doesn't have the data sources included with the post, could you either include them here or package the workflow? 

[abacon]

@c-yun Does this do that job for you?