Filtering out Status based on two criteria - Not working!
Hi,
I'm at a loss and could use some guidance please!
I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do.
I have tried all the options (Is not blank, Is not equal to, does not contain, is not one of) to no avail. It filters out Complete but shows Not Required statuses).
When I go into the project and set filters, it works correctly (filtering out Complete and Not Required statuses).
Your help is greatly appreciated. Thank you!!!
Best Answers
-
Hi @Kathy PPT !
I think you may just need to change the "OR" with the first two filter conditions to "AND"
it looks like the "Complete" items are correctly filtered out because those would be at 100% (another condition you have set).
Does that work?
-
@Kathy PPT Glad to help and glad you got your report working as you wanted! …Using "AND" for those conditions in the filter means you want to exclude both records with Complete or Not Required status.
If the Status column is a drop-down, you could also change the filter to "is not one of" and select both the Complete and not Required statuses (all in the same 'condition") rather than having two lines in your filter for that. End result will be the same!
have a great rest of your day. :)
-
Got it!!!
Answers
-
Hi @Kathy PPT !
I think you may just need to change the "OR" with the first two filter conditions to "AND"
it looks like the "Complete" items are correctly filtered out because those would be at 100% (another condition you have set).
Does that work?
-
@Jennifer Kurtz - Thank you, you were right! Though I don't quite understand how it works as a row can't have both Complete and Not Required status.
-
@Kathy PPT Glad to help and glad you got your report working as you wanted! …Using "AND" for those conditions in the filter means you want to exclude both records with Complete or Not Required status.
If the Status column is a drop-down, you could also change the filter to "is not one of" and select both the Complete and not Required statuses (all in the same 'condition") rather than having two lines in your filter for that. End result will be the same!
have a great rest of your day. :)
-
Got it!!!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives