negative flag

[krish2459]

Hi, 

I want to consider the % of sales only if the number of negative values is >=3 in last 6 months and create flag Repeat affender.

Attaching the sample data.

Thanks,

Krish

[morgankejerhag]

I think you have to explain a bit more. % of sales = [Something]/[Something else] - what is those parts?

The first product in your example doesn't have three negative values and is Yes?