Forum Discussion
Ossy81
2 years agoHelper I
Get the correct average price
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
pls try this