Excluding a substate

[KathersC]

Hello,

This is my first post so apologies if I get anything wrong!

I have a report feeding from alm_hardware which shows me which machines with a state of In Stock or In Use are due to be retired this quarter. However, I want to exclude any devices with a substate of Pending Disposal from this report, but when I select that as a pending condition (substate is not pending disposal), the result excludes all devices with a state of In Use. 

Am I missing something really simple?! Screenshots attached to show the selected conditions.

[Naveen20 · Accepted solution]

Try this fix
Fix it with an OR clause so empties show - Change filter condition
Substate is not Pending disposal OR Substate is empty

[KathersC]

Thank you so much! Really appreciate the quick response