Excluding a substate
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12 hours ago
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11 hours ago
Try this fix
Fix it with an OR clause so empties show - Change filter condition
Substate is not Pending disposal OR Substate is empty
