Discussion Board for collaboration related to QlikView App Development.
rangesum(filed,0) ? what it returns
if field is numeric
whatever value of field, it will be returned
if Field is alphabate
If Field is Null
View solution in original post
"If Field is Null
I don't think that statement is true. From the Help for RangeSum():
"As opposed to the + operator, rangesum will treat all non-numeric values as 0. "
A Null in the Field vale will be treated as 0, and RangeSum() will return 0 in the example given.