rangesum?

[#1]

rangesum(filed,0)   ?   what it returns

[MK_QSL · Accepted solution]

if field is numeric

whatever value of field, it will be returned

if Field is alphabate

0

If Field is Null

Null

[rwunderlich]

"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