Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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.
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.
thanks