Get the correct average price

[Ossy81]

Hi,

i need to get the average price per products from sales. The problem is that the average is taking the number of "repeats" of the price into account. While i want to to know the average price per product.

So if this is the price per product:

In the sales table the price is shown per order like:

How can i get the right average price? I'm a bit stuck

[Ahmedx · Accepted solution]

pls try this

[Ossy81]

Works like a charm! Thanks Ahmed for the quick help!