remove no value calculated rows

Summary

when creating a calculated column - exclude rows that return "No Value"

Content

Hello,

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?

Thank you.

Scott

Version

18B