Average

[tracycrown]

Dear all

I would like to set the average column equal to average of column(3) (ie $677.59), kindly advise how to write the formula.

Thank you

Tracy 

[Frank_Hartmann · Accepted solution]

try this:

avg(Total Price*Quantity)

[tracycrown]

Dear Frank_Hartmann

Many thanks for your quick response.

Kindly advise why avg (total column(3)) is not working as it is the same as avg(total Price*Quantity).

Also, how to make avg(total column(3)) work, am I missing anything ?

Thank you

Tracy 

[Frank_Hartmann · Accepted solution]

No, you are not missing anything. You just cannot use column function in this case!
The Column() function operates on a strictly row-by-row basis.
You will have to use the proposed formula in order to achieve your output!

hope this helps!