Count above target rate

[danieldors]

Hello,

Im trying to count the number of employees which are over 95% of the following metric:

(sum(AllAppTimely)/sum(AllAppTotal)

Thank you.

[MayilVahanan]

Hi @danieldors 

May be try like below

Sum(Aggr(If(sum(AllAppTimely)/sum(AllAppTotal) > 0.95, 1), Employee))

or

Count({<Employee= {"=Employee = (sum(AllAppTimely)/sum(AllAppTotal)>0.95"}>}Distinct Employee)

[Shirley102]

Thanks for the information