Conditional Filtering in Report Builder


Maybe my logic is wrong but I cannot get my custom report to filter correctly. I would like the report to show all persons except Janine Gentile. Also, I would like to omit Meetings and Management from hours shown for Wenjing Jiang. Could you assist? When I run the report shown in the screen capture below, Meetings and Management still show up on the report for Wenjing.

Tags report-builder
Asked by Janine Gentile on Thu 9/11/14 5:34 PM
Sign In to leave feedback or contribute an answer

Answer (1)

Drake Sigler Thu 9/11/14 5:34 PM

Hi Janine,

I think you can go at it from this angle. First, change your #4 filter to be Person is NOT one of Wenjing Jiang. Then, use this as your advanced filter expression:

1 AND 2 AND 3 AND (4 OR 5)

I think this is what you need. Let me know how it works!

No feedback