SHOWNULLAS

Use the SHOWNULLAS function to customize how to display null values in your reports.

Syntax

SHOWNULLAS.<TYPE>

Arguments

TYPE- Can be BLANK, HYPHEN, CUSTOM, or ZERO. Pass the custom value to use when the TYPE is 'CUSTOM'.

Example

SHOWNULLAS.BLANK
SHOWNULLAS.ZERO
SHOWNULLAS.HYPHEN
SHOWNULLAS.CUSTOM('custom text')

Using the SHOWNULLAS function with variables

The null values in the report have been updated to custom identifiers with the SHOWNULLAS script.

SHOWNULLAS function in action