resutl row with average multiplied by sum

[Former Member]

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?

[Former Member]

Hi Uday,

Is the intention to do this for all values or only for results?

If this is only for results then we can use the calculation feature of the col 1 to force this to avg and then col 2 as summation.

Define a formula col 3 and define this as col1 times col 2.

Naveen.A

[Former Member]

This is for the results row only. What you said will not work. Because in col C, no matter what i do with the other columns, it's always doing

for after aggregation - (sum of col 1) X (sum of col 2).

for before aggregation - sum of (col 1 X col 2)

It's never doing (avg of col 1) X (sum of col 2) even though my result for col 1 is avg.

[Former Member]

Can you not create a formula (local ot otherwise) to calculate that?