This content has been marked as final. Show 3 replies
Basically, I want to countd the number of [W2k] that exceeded 700 [AHT].
Is there any formula that will allow me to do that?
I have tried countd (if [AHT] >= 700 THEN [W2K] end) but the result is not correct... (Showing me 318 instead of 244)
I think countd (if AVG([AHT]) >= 700 THEN [W2K] end) would work but I was prompted with this error "You cannot mix aggregated with non-aggregated..."
I have attached the workbook here.
Many thanks for your help:)