remove no value calculated rows
Summarywhen creating a calculated column - exclude rows that return "No Value"
I'm creating a calculated column by searching for a substring within another columns text. Many (about half) of the records don't have the string in the text, but a row is generated with "No Value." I want to exclude the "No Value" rows from the report, but the filter won't let me do that.
So how do I exclude the "No Value" rows?