IBM Support

@ shown instead of empty cells in IBM Cognos Insight

Technote (troubleshooting)


An empty cell is displayed as @ in a crosstab in IBM Cognos Insight, instead of no value being shown. IBM TM1 Architect shows all the values correctly.


An invalid format was set in element attributes for the dimension. In this case a c:"" was set, to exchange all 0 values with an empty space only for this one dimension.

Resolving the problem

Set a format as described in the documentation:

Example pattern: #,##0.00;(#,##0.00);"";"" .

The first two values in this pattern, represent the positive and negative values. The 3rd and the 4th value represent zero and NULL values. This will format all values with two decimals and zero or NULL values will be displayed as empty string.

Document information

More support for: Cognos Insight

Software version: 10.1, 10.1.1, 10.2

Operating system(s): Windows

Reference #: 1621304

Modified date: 04 January 2013

Translate this page: