Total Count of value over 5 week span

[ronaldovuiv]

Hi all,

I would like to create an expression that would give me the total number of yellow boxes (any value greater than 40) for all Test #'s in the example below. So the desired number for the example below would be 12. I am grateful for any suggestions.

KR,

Aaron

[sunny_talwar]

I don't see why it wouldn't work for < 2, although 0 might be something related to the issue of missing or nulls. Difficult to say.