CFLib.org – Common Function Library Project

Description:
With this UDF, you can get the total of all rows for any given query column. Assuming of course that the column you specify contains numbers! :-)

Return Values:
Returns a number.

Example:

<cfset foo = queryNew("total")>
<cfset queryAddRow(foo,10)>

<cfloop index="x" from=1 to=10>
	<cfset querySetCell(foo,"total",x,x)>
</cfloop>

<cfoutput>#columnTotal("foo.total")#</cfoutput>

Parameters:

Full UDF Source:

<cfscript>
/**
 * This UDF calculates the total of a column from a query.
 * Version 2 by Raymond Camden
 * 
 * @param qryColumn 	 The name and column of the query, i.e. foo.total (Required)
 * @return Returns a number. 
 * @author Scott Barber (&#99;&#104;&#97;&#114;&#108;&#101;&#115;&#98;&#97;&#114;&#98;&#101;&#114;&#64;&#104;&#111;&#116;&#109;&#97;&#105;&#108;&#46;&#99;&#111;&#109;) 
 * @version 2, May 13, 2003 
 */
function columnTotal(qryColumn){
	return arraySum(listToArray(evaluate("valueList(" & qryColumn & ")")));
}
</cfscript>