If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Blank spaces in Crosstab

Started by lebronjames, 29 Jan 2009 12:59:03 PM

Previous topic - Next topic

lebronjames

Hello,
I have a basic crosstab report created. It involves a large set of data and several of the combinations don't exist.

For example, I have Account IDs as the rows and Locations as the columns. But each location does not use all the accounts. Thus a blank space shows up because there is data in the row for a different location but none for this one.

How do I get the report to say that if there is a null value or blank space, replace it with "N/A"

kaevne

Highlight the data space, go to properties, and edit the data format.  Change the "missing Values" property to fill in as '0' or whatever you want.

Kaja

Click inside measures and go properties. Under Data, click on Data format. I'm assuming that the format type is text for your report. Inside properties, next to 'Missing Value Characters' type N/A. This should solve your problem