You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

remove no value calculated rows

edited Oct 3, 2018 2:37PM in Reporting & Analytics for B2C Service 4 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!