Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Im trying to calculate the number of employees completing more than 15 drivers per day(average for the month), I tried the expression below with no luck.
((sum(Aggr(If(avg({<MonthYearProduction={"$(=Max(MonthYearProduction))"},[Work Type]={'Generic-Full'}>} [Total Driver]> 15),1),[FLA ID-pas])))/count({<MonthYearProduction={"$(=Max(MonthYearProduction))"},[Work Type]={'Generic-Full'},[Total Driver]={">1"}>} distinct[FLA ID-pas]))
