Suppress or display zeros

You can selectively suppress or display rows that contain only zero values in a Dynamic Report.

About this task

Zero suppression is controlled by the value of the ZeroSuppression argument to the TM1RPTVIEW function. If this argument value is 1, zeros are suppressed in the Dynamic Report; if the argument value is 0, zeros are not suppressed in the Dynamic Report.

Procedure

  1. Unhide the rows above the Dynamic Report until you see the cell that contains the TM1RPTVIEW function.
  2. To suppress zeros, change the second parameter to 1. To show zeros, change the second parameter to 0.