Column Totals

[nav1]

Is there an easy way to total a column of numbers returned in a query? For
example, I am producing a sales report for 10 sales people. The database query
returns 10 rows, each with a sales amount. I need to compute a total of those
10 amounts. I am currently re-querying the database without a 'group by'
clause to get the total amount. It seems like there should be a CF function to
get that number without an additional query.

[jdeline]

SELECT ..., SUM(salesAmount) AS total, ...

[Scott*e]

<CFSET VARIABLES.TOTAL = 0>
<CFOUTPUT QUERY="MYQUERY">
<CFSET VARIABLES.TOTAL = VARIABLES.TOTAL + MYQUERY.FIELDNAME>

.. display fields as normal

</CFOUTPUT>
<CFPOUTPUT># VARIABLES.TOTAL#</CFOUTPUT>

[mxstu]

And another method ...

<cfset grandTotal = ArraySum(ListToArray(ValueList(yourQuery.SalesAmou ntColumn)))>