Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I've got it now, sorry
=Count({<Availability= {"=Avg({< $(vSetMTD)>} Availability) < System_Norm "}>} SystemID)
I've got it now, sorry
=Count({<Availability= {"=Avg({< $(vSetMTD)>} Availability) < System_Norm "}>} SystemID)