Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I wist to Count number of employees in current period:
Count({$<MonthYear ={"$(=Max(MonthYear))"}>}distinct EmployeeID)
but I would like to add to only Count [Employee Category] 'A' .
How can I do this?
Try this
Count({$<MonthYear ={"$(=Max(MonthYear))"},Employee Category={'A'}>}distinct EmployeeID)
Try to expand your set with another modifier for [Employee Category] like this:
Count({$<
[Employee Category] = {'A'},
MonthYear ={"$(=Max(MonthYear))"}
>}distinct EmployeeID)
Try this
Count({$<MonthYear ={"$(=Max(MonthYear))"},Employee Category={'A'}>}distinct EmployeeID)
Try to expand your set with another modifier for [Employee Category] like this:
Count({$<
[Employee Category] = {'A'},
MonthYear ={"$(=Max(MonthYear))"}
>}distinct EmployeeID)
Seems to work!
Thank you!