Replace with 0

[deepak2k2]

Hi,

In my crosstab, i'm getting one of the values as '\0'.  Because of this not able to do the aggreage function (sum). 

How do I replace '\0' as 0 and do the calculation?

[deepak2k2]

In the data format ->Currency -> Any Error Character, i could change from '\0' to 0.  But its not taken in account while doing the sum.

Ex. 10+10+0('\0')=0

How do i fix it?

[cognos10]

U can format the column using data format

format type = number
zero value character=0