SET analysis Help

[Meg00]

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?

[BlakeGri2093 · Accepted solution]

Try this

Count({$<MonthYear ={"$(=Max(MonthYear))"},Employee Category={'A'}>}distinct EmployeeID)

[Vegar · Accepted solution]

Try to expand your set with another modifier for   [Employee Category] like this:

Count({$<
   [Employee Category] = {'A'},   
   MonthYear ={"$(=Max(MonthYear))"}
    >}distinct EmployeeID)

[Vegar]

@BlakeGri2093 You need to bracket your Employee Category modifier either like this [Employee Category] or like this "Employee Category" in order to get your expression to work.

[Meg00]

Seems to work!

Thank you!