Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
rangesum(filed,0) ? what it returns
if field is numeric
whatever value of field, it will be returned
if Field is alphabate
0
If Field is Null
Null
if field is numeric
whatever value of field, it will be returned
if Field is alphabate
0
If Field is Null
Null
"If Field is Null
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.
-Rob