Help doing maths

[kris f]

Hi
I have a database that has amongst others the fields "Price" and "Quantity".
What i need to do is multiply the "Price" by the "Quantity" for each record
and then add them all up to give a "Subtotal"

I think i am way of track with as the result is nowhere near correct

<cfquery name="GetSubtotal" datasource="#Application.dsn#">
SELECT (SUM(Price)) * (SUM(Quantity)) as Subtotal
FROM ProductsOrdered
</cfquery>

Then outputed in the page as

<cfoutput>#GetSubtotal.Subtotal#</cfoutput>

:( Thanks in advance

[Mr Black]

SELECT SUM(Price * Quantity) as Subtotal FROM ProductsOrdered WHERE . .if needed. . GROUP BY . . . if needed . . .

[kris f]

:) Thank You i was messing around for hours