I am writing a query where I have to calculate the average price of each material.
Example, Material M1 can have many vendors, say,V1 and V2
I have to calculate for M1 =
(Price * Qnty)for V1 + (Price* Qnty)for V2...../Total Quantity for (V1V2+....)
Likewise I have to do for all the materials
I have taken in rows, material and then vendor.
In columns I have the price and qnty of all the materials for respective vendors.
How can I do the above calculation of average?
Thanks and regards,
Message was edited by: