Average Query

[philljo]

Hi,
I have a table with lots of call data in groups for different dates. And I need to do a query to work out weighted averages...eg.

Group calls Date SpeedAnswer
10 129 5/5/09 10
20 30 6/5/09 11
10 500 6/5/09 15

I need to do a query which will group all 10 together, and work out the weighted average. So you would need to do formulae Calls*SpeedAnswer for each group 10 and divide by total calls.

Sorry if this isnt explained very well.

Cheers

 

[Yard]

DOn't follow your data. "group all 10 together"....which 10?

If you multiply Calls*SpeedAnswer and divide by Calls you just get back to SpeedAnswer.

What are the other criteria for your query? e.g. all calls for Group 10, or all calls for a certain date?

 

[Fazza]

Hi, Like below? BTW, suggest caution with field name 'Group'. HTH, Fazza

SELECT T.Group, Sum(T.calls*T.SpeedAnswer)/Sum(T.SpeedAnswer) AS [WtdAvg]
FROM myTable T
GROUP BY T.Group