Sign in

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

Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
BUILT ON