Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
EmployeeID | PassportNo |
1 | 45783 |
2 | 78142 |
4 | 39874 |
5 | 56874 |
6 | 12457 |
8 | 74871 |
9 | 5471 |
I have totally 10 Employees. here i have entered only who are all having passport those employee id only entered. and i want entered employee id status = 'yes' and not entered employee id status = 'no' how to write expression ??????
do you want to enter manually or you have satus information stored in some other table
Hi,
Try this: count(Distinct {<Status = {'yes'}>} EmployeeID)