Show Blank Cells For Zero and Missing Values

You can format the measures in your report to show blank cells for the following values in crosstab displays:

• zero values
• divisions by zero
• missing values

For example, you prepared a IBM® Cognos® PowerPlay® report that outlines the five-year return for all your mutual funds. Because some funds are only three years old, there is no data for the first two years. This missing data appears as zeros, which incorrectly implies a zero return for these funds. You change these values to blanks.

Zero and missing values appear as blanks in only crosstab displays. In all other displays, zero values appear as n/a unless specified otherwise by your administrator.