query help

[buggy2]

I am looking to run a query on a table which will determine the weighted average of a field. The table is designed as follows:

Name | Amount | Rating


I am trying to calculate Sum((Amount*Rating)/Sum of Amount), but I keep on getting aggregate errors relating to 'Sum of Amount'. Any ideas.

 

[Philem]

Hullo. Let me see if I understand this correctly. What you have is, in effect:

Sum((A*R)/Sum of A)

Right? Here's hoping you have A calculated elsewhere. Try this instead:

Sum((A*R)/A)

and see if that gets you want you want.

HTH

P

 

[buggy2]

thanks the sum piece was incorrect before this query.

It was one of the those monday morning things.

Thanks again.