Skip to main content
Planview Customer Success Center

How to filter out records from reports using "Not Like" or "Not Equal To"

Question:
How to filter out records from Report Designer reports using "Not Like" or "Not Equal To" ?


Answer:
Unfortunately, "Not Like" or "Not Equal To" options are not available when creating filters.

However, a custom field using the CASE expression can be added to the data collection, in order to achieve the same purpose. The custom field could be formulated as in the examples below:

Ex 1:
CASE WHEN [SomeField] like '%SomeValue' THEN 1 ELSE 0 END

Ex 2:
CASE WHEN [SomeField] IN ('Value1', 'Value2') THEN 1 ELSE 0 END

Then a filter can be created as "[CustomField] Equal To 0", which would act as a "Not Like" or "Not Equal To" condition, therefore the report would only display the relevant records.