This content has been marked as final. Show 3 replies
I have a straight table with 14 columns consisting of numerical data. In one or two columns I have null data which I represent by the symbol "-". Now, if I write an expression in the 15th column of the straight table as col(1)+col(2)....+col(14) I get the sum as "-".
If I remove the particular columns consisting of the null values, for eg: if col(2) is null (represnted by "-") & I remove it from the expression for summing up as col(1)+col(3)...
I get the summation value.
How can I discard null values and add up only those columns which has value in it. The values are all numerical.
Thanks to All in advance for suggestions,