Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to count Employee code that starts with 3, what should I do?
=Count(DISTINCT {<EmployeeID= {"=Left(EmployeeID,1) = 3"}>} EmployeeID)
=Count(DISTINCT {<EmployeeID= {"=Left(EmployeeID,1) = 3"}>} EmployeeID)