Count if

[EsmeeM]

Hi all,

I'm trying to return a count of the systems that perform under norm of the last month's data. I have a table with SystemIDs, Dates and availability values.

So far I have tried the following syntax with no good results:

=Count({<Availability = {"<=0.99"}, $(vSetMTD) >} SystemID)

(Result is 0)

It also does not work without the last month $(vSetMTD) restriction. 

Can anyone tell me what I am doing wrong here?

Thanks in advance!

[EsmeeM · Accepted solution]

I've got it now, sorry

=Count({<Availability= {"=Avg({< $(vSetMTD)>} Availability) < System_Norm "}>} SystemID)