Question:
Hi All,
We have a scenario where quantity for a material and unit cost of the material must be multiplied to get the total cost. However, both of these information are from different datasource.
eg.
Material QUantity Costs/Unit Total Costs
A 10 3 30
B 20 5 100
C 15 2 30
D 50 6 300
Total costs =460
However, when we drill down by only Company Code (assuming the is only one Company Code)
Company Code Quantity Costs/unit Total Costs
XYZ 95 16 1520
Which is WRONG. it should be 460 and not 1520. Is there anyone can help me in this. We need to calculate at the material level.
thanks a lot!
Answer:
Nobody's life seems to be in danger (see forum rules) -> locked