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.
You saying you can use this expr in text box? If yes, may be a slight addition to your expression else might throw an error. As IF should return some value.
Can you check your expr will throw an error with Nested Aggr Not allowed or a script error. Just wondering.
= Count(Sum(Aggr(Sum(Value),Example,Week)) > 40))