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]))