Skip to Content
0
Former Member
Dec 20, 2006 at 11:22 AM

Average value of a material

21 Views

Hi All,

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,

SB

Message was edited by:

Sharmishtha Biswas