Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
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
29
Views
2
Comments
edited Nov 2, 2018 8:31PM in Reporting & Analytics for Sales 2 comments

Summary

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

Content

Hello,

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.

Register

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