Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Im trying to count the number of employees which are over 95% of the following metric:
(sum(AllAppTimely)/sum(AllAppTotal)
Thank you.
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)
Thanks for the information