Quoting from the Admin tool Help:
Help(menu) --> Contents and Index (first item on the menu)
Index (tab)
Search for "COLSUM"
"
For a given column on a table or results list field, returns the sum
of all values as a real type.
Following are exceptions:
For char columns, converts the column values to numeric and sums
up the numeric values.
If the column type is currency, the sum of the currency value is
calculated, and the currency type is ignored.
If the column type is enum (radio button or selection), the sum
of the enum value is calculated.
COLSUM ignores date/time, date, and time columns; and returns NULL.
"
Are you seeing a different behaviour?
ARS101
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
On 10/10/06, Christopher Pruitt <[EMAIL PROTECTED]> wrote:
Quick question for the list.
When using the COLSUM we are getting some strange results.
My question is how does COLSUM handle NULL values?
Does it ignore them or will the NULL value cause the COLSUM to fail?
Christopher Pruitt
Consultant Specialist
EDS - Bank of America
I3-Inventory IW Infrastructure Team
Phone: +1-972-605-7702 (8-835)
mailto:[EMAIL PROTECTED]
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
