Straight table Expression

[srikantj]

Hi Qlikss

I have straight table with columns

id ,name, description, quantity, goods ,column(4)+column(5)

i have total 1000 rows.  the last expression column(4)+column(5). is giving right results for almost 995 rows

but for that 5 rows it is showing nulls. which is  not correct. this is very simple sum and i am loading data from excel

how can it go wrong for only 4 or 5 rows. is there anything wrong with straight table.

Suggest me...

[sunny_talwar · Accepted solution]

Try with RangeSum()

RangeSum(Column(4), Column(5))

[srikantj]

why it wont work with normal sum sunny..

[srikantj]

Thanks.. but why it won't work with normal sum when my formula is correct

[sunny_talwar]

Because if one of the two columns have null in them, + won't be able to sum number with a null. But RangeSum() will sum regardless of the nulls.