Skip to Content
0
Former Member
Dec 07, 2011 at 05:06 AM

How To Calculate Average Price

246 Views

Dear experts.

I have the following data:

Product.............Store Location.............Price

Bottled Water.............London.............2.00

Bottled Water.............Birmingham.............1.50

Bottled Water.............Manchester.............1.00

Candy Bar.............London.............3.00

In BEx query, I need to display the average price of Products without the Store Location. When I execute the query, only the total is displayed as shown below.

Product.............Average Price

Bottled Water.............4.50

Candy Bar.............3.00

How can I change the price result to show the average price i.e. $1.50?

Thanks.