Skip to Content
Former Member
Jul 14, 2008 at 06:53 PM

resutl row with average multiplied by sum


I have a query where I need to multiply the average of col 1 with the sum of col 2 to get col 3.

That is, Col 1 Result is average of all values (say 205), col 2 result is sum of all values (say 140), I want col 3 result to be a product of those 2 values, that is 205 X 140. Looks like this is not possible using exception aggregation. Any ideas on how to do this?