Version 2021

Report Data Options dialog box: Null Values

The Null Values subcategory allows you to display a specified value in place of null or missing values on a report. Often you would rather see a zero or the word NULL instead of a blank cell.

You can replace nulls in the display of the final report (the Null display settings) or in the calculation of the report (the Aggregation null values). This is only a temporary replacement; it does not change any values in the data warehouse.

The Missing object display option is similar to the null values settings but is used for Freeform SQL reports that may reference unavailable objects.

  • For Null display settings, you can enter a value to be displayed on the report in the following situations:

  • An empty value is retrieved from the warehouse.

  • An empty value is calculated in the cross-tabulation process.

  • An empty value appears when the report is sorted. The replacement value is not displayed on the report, but is used to sort the report.

    For example, if metric values are sorted in descending order and blank values (or nulls) appear first, you can specify that the null values are treated as zeros. The null values will then display at the bottom of the report. For further instructions, see Sorting so null values appear at the top or bottom of a report.

  • For the Aggregation null settings, you can enter the replacement value to use if a metric value cannot be calculated at the desired level.

  • For Missing object display, you can enter a value to be displayed when a Freeform SQL report references unavailable objects. For example, you mapped the attribute description and ID forms of the Region attribute, but included only the ID in the SELECT clause. When the report is executed, the description cannot be displayed because it has not been retrieved from the data warehouse.

Related Topics