What's new in Customer Journeys?

Connect and learn more! ×
Showing null values as "Blank" — Cloud Customer Connect
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

Showing null values as "Blank"

Received Response
edited Nov 2, 2018 8:31PM in Reporting & Analytics for Sales 2 comments


How do I show null values with the word "Blank" or "NA" or something similar?



In the Product Dimension for 'Product Name', we have some blanks due to poor process. We are trying to improve the process of always adding a product to an opportunity. To help us do that, we are using Analytics. I created a pivot table showing all of the opportunities we have open by Product Name. We have some that don't have a product so I want to show the word "Blank" or "NA". I'm using this case statement and it's not working. Any thoughts? 

Howdy, Stranger!

Log In

To view full details, sign in.


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