Skip Navigation
Expand
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 Service Cloud, 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:

  1. Edit the Report -->
  2. Right click on the desired column -->
  3. Select Edit Format -->
  4. Under NULL Values, select "Display Blank."

Column Format window > Text tab > NULL Values > options: Display Blank or Display as No Value

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

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.