Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello evreyone,
First of all, thanks for your help.
I need to know how can I cont the number of lines that is under 95% for example. My column is following:
| |
0,12453% | |
0,12478% | |
0,12517% | |
0,12539% | |
2,05141% | |
2,05156% | |
2,05156% | |
5,09936% | |
5,09971% | |
5,12268% | |
5,18430% | |
9,24303% | |
9,24309% | |
9,28682% | |
9,34172% | |
15,48626% | |
17,86872% | |
17,86872% | |
17,86876% Thanks, |
Try
=Count( If([Calculated Availabilty (%)] <= 0.95,[Calculated Availabilty (%)])
e.g in a kpi object expression.
Also a set expression might work:
=Count( {< [Calculated Availabilty (%)] = {"<=95,00000%"} >} [Calculated Availabilty (%)])
Try
=Count( If([Calculated Availabilty (%)] <= 0.95,[Calculated Availabilty (%)])
e.g in a kpi object expression.
Also a set expression might work:
=Count( {< [Calculated Availabilty (%)] = {"<=95,00000%"} >} [Calculated Availabilty (%)])
Thanks. It works.