Column must show "NA"

[mrcool]

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

[BIsrik]

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

try this..

Srik

[mrcool]

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

[BIsrik]

plz update the topic..

Srik