Skip to Content
Former Member
Jan 20, 2006 at 05:28 PM

Values Not being calculated in the query



I have a customer with contract from 01/01/2006 to 12/31/2006 for the same material.

Material Qty Price

A 25000 19

A 15000 18

In a report the query shows

Material Qty Price

A 40000 37

I need to find out Why its not showing me weighted average price of 18.625 instead of 37 which is not correct.

Any Idea?