weighted average

[ValeriaBonini]

Hi, I have a table like this:

Order_Id       Price     Quantity

1                      5             10

1                      7              3

1                       4             34

How can I calculate the weighted average of the price based on the quantity?

[Aurelien_Martinez]

Hi,

If it's in chart:

Sum(Price *Quantity) / Sum(Quantity)