I have 2 custom objects:

Candidate & Worker

Candidate has a field that is a lookup called "Tech Screener:" and allows me to select any worker.

Lets say I have 10 candidate records. I also have 5 worker records, Sue, Joe, Bob, Jim, and Jen. Sue is the tech screener on 2 candidates, Bob is on 3, and Jim is on 5. However Joe and Jen have not been chosen as tech screener at all.

How do I write a report that shows workers who have not been selected in any candidate "tech screener" fields. (that will show Joe and Jen)

Its easy for me to get a report from the candidate side and group by tech screener, but I cant figure out how to go the other direction? Custom report type doesnt show "Tech Screener" as option when starting with workers.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.