COGNOiSe.com - The IBM Cognos Community

Hi Frnds,

               Here is my requirement. If data is not present in any column r row r cell it must show 'NA'. I have created a variable with the following condition "If Queryitem is null then (1) Else (0)." i.e if (1) it shows 'NA' else the value.

I have applied conditional text for a column with the above condition. But its not working.

The problem is If anyone of the cell in a column in null the entire column is showing as "NA".

For Example.

          JAN
1999  19
2000       
2001   8
2002  10
2003     
2004  23
2005    3
2006  56

My Requirement is
                        JAN
1999               19
2000               NA     
2001                8
2002               10
2003               NA   
2004               23
2005                 3
2006               56

Thanks in Advance,
Mrcool

select the data item and in properties..select the data format, and then number and then set the missing value charecters.

try this..

Srik

Thanks Srik...I thnk this will solve some part of my problem....

plz update the topic..

Srik