Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
Null value display options in Reports
Answer ID 8810 |
Last Review Date 10/09/2018
What options are available for formatting null values in a report?
Environment:
Analytics
Oracle B2C Service, All versions
Resolution:
In a report null values can be displayed in several formats depending on the column type and your desires. Numeric columns default to "0" for null values. Text columns default to "No Value." Null fields can be changed to blank space rather than a zero or "No Value" by:
- Edit the Report -->
- Right click on the desired column -->
- Select Edit Format -->
- Under NULL Values, select "Display Blank."
Click to enlarge image
See the following for additional information regarding null filtering:
Answer ID 1744: Values of the Operator field when configuring report filters
Answer ID 8791: Filtering by NULL values in a report