Hello,
I am trying to count consecutive value(CCV) in a row and have it give a rating of green yellow and red. Green Rating 3 consecutive days or less below .9, Yellow Rating is 4 to 7 consecutive days below 0.9 and RED rating is anything 8 consecutive days below 0.9. Day 13 it turns back to green because they achieved .9.
Example:
CCV Rating
1 Green Day 1
1 Green Day 2
.98 Green Day 3
.9 Green Day 4
.8 Green Day 5
.7 Green Day 6
.8 Green Day 7
.8 Yellow Day 8
.75 Yellow Day 9
.85 Yellow Day 10
.86 Yellow Day 11
.75 RED Day 12
.9 Green Day 13
Bookmarks