SETSUPPRESSZEROS

SETSUPPRESSZERO can be used to show or hide zero values in reports.

Syntax#

SETSUPPRESSZEROS(VALUE)

Arguments#

VALUE - Pass a boolean value of TRUE or FALSE.

Example#

SETSUPPRESSZEROS(TRUE) //Suppresses zeroes
SETSUPPRESSZEROS(FALSE) //Displays zeroes

Set suppress zeroes

Notice how the Depreciation row that only contains zeroes is suppressed when the SuppressZeroes button is clicked and displayed again when the DisplayZeroes button is clicked. The buttons use the SETSUPPRESSZERO script internally to hide and display zero values.

Suppress zeroes script in action

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