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.
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.