Count for Current Day

[danieldors]

Hello,

I have the following expression below which Im trying to find the percentage of workers for the most current day over 15 driver for that day. Im not sure what is wrong with it.

((Sum(Aggr(If(sum([Total Driver]) > 15,[DD_Production.Date.autoCalendar.Date]={"$(=Max([DD_Production.Date.autoCalendar.Date]))", [Work Type]='Generic-Full',1),[FLA ID-Worker ID])))
/
count({<[Work Type]={'Generic-Full'}>}distinct [FLA ID-Worker ID]))

Thank you

[rubenmarin1]

Hi, maybe it's a syntax error and you want something like?:

((Sum(Aggr(If(sum([Total Driver]) > 15 and [DD_Production.Date.autoCalendar.Date]=Max([DD_Production.Date.autoCalendar.Date]) and [Work Type]='Generic-Full',1),[FLA ID-Worker ID])))

Or those conditions should be inside a set analysis, like:

((Sum({<[DD_Production.Date.autoCalendar.Date]={"$(=Max([DD_Production.Date.autoCalendar.Date]))"}, [Work Type]='Generic-Full'>} Aggr(If(sum({<[DD_Production.Date.autoCalendar.Date]={"$(=Max([DD_Production.Date.autoCalendar.Date]))"}, [Work Type]='Generic-Full'>}[Total Driver]) > 15,1),[FLA ID-Worker ID])))