How To Do Math on a Query RecordSet? 1

[3dColor]

I have a query that returns a record set of sale prices. I want to add those sales number and the then divide it by the recordcount to get the average.

I am pretty sure I can handle the math function to divide the total by the recordcount - but how do I add up the sale prices in to a total?

Do I need to create a loop for this?

 

[ecobb]

<cfquery>
Select Sum(YourColumnName) AS SalesTotal
From YourTableName
</cfquery>

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[3dColor]

Thanks!

 

[philhege]

Adding to ECAR's reply,

the WHERE condition for the SUM query should be the same as that used in your other query.

 

[imstillatwork]

and just to add, the SUM function should be used in the same query that is getting the data now, not a separate query just for the sum. ecar was just giving an example of the SQL function.

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!