Supreesion option not working

[barrysaab]

Good morning,Gurus.I have crosstab report and there are some empty cells in it,all i want to do is to replace those empty cell with zero,i have tried suppression and options,unfortunately the report output still displays zero.Appreciate your help.Thanks

[a.chamkeri]

Hi,

You want to display a 0 instead of a blank cell.

Chk if this thing works,

Create a data item with the following calculation:

if ( IsNull(value) ) then (0)
else
(value)

Thanks

[barrysaab]

Thanks,a.chamkeri.I appreciate your reply,but just wondering why this suppression option is not working in my case.Could someone help,please.Thanks

[RobsWalker68]

Hi,

In this example suppression will not work as suppression works at the row or columnar level and the column 2004 has values as does the row mountaineering equipment. 

To replace the null value with something more meaningful set the data format for the fact cells and enter an appropriate value in the "Missing Value Character" property.

Rgds

Rob

[barrysaab]

Thanks, Rob.Sorry i couldn't able to get you,what i means to say suppression option is substitute with the value provided,this is not happening here.Could you please elaborate.

[Lynn]

Suppression means to exclude rows (and/or columns) when the WHOLE row (or column) is empty or zero. It has nothing to do with substituting values. Did you try the missing values property as Rob suggests?