help on if expresssion

[jip31]

Helllo

I try to count the number of employee ID like this but it doesnt works

What is the problem please?

if(EmployeeID='2', COUNT(EmployeeID))

[Or · Accepted solution]

If() goes inside the count(), not vice versa.

Count(If(EmployeeID='2',EmployeeID))

You could clean that up with Count({< EmployeeID = {2} >} EmployeeID) and not use if() at all.

[jip31]

thanks