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?
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?
U can format the column using data format
format type = number
zero value character=0