COUNT DISTINCT

I am working on testing data that has both pass and failures. The data is in such a way that it will not move to the next device unless it passes all the tests. So the devices have both passes and failures. now i want to know if i could get the count of devices that never had a failure. what function do i use

0 0 48
0 REPLIES 0
Top Labels in this Space