Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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,
Tutan
Hi Tutan,
NumSum() function may do this job. Let try
=NumSum(Col(1),Col(2),Col(3))
Regards,
Sokkorn
Hi Tutan,
NumSum() function may do this job. Let try
=NumSum(Col(1),Col(2),Col(3))
Regards,
Sokkorn
Sokkorn may have the best technique there but you can also put IF statements to check for the null values:
If(Isnull(Col(1)), 0, Col(1)) + If(Isnull(Col(2), 0, Col(2)) +......
works perfectly fine...Many Thanks for the help.