Calcuation Confusion Pls Help

[rmbohra]

I have created queries from Incoming Raw Material and Out Going Raw material Tables

Now how to get balance Stock of Item wise,

My Query Look as under
item wt In Coils Out Coils Wt Bala Stock
part A 100 kg 10 3 30 Kg 7
part A 100 kg 10 5 30 Kg 5

I want that Balance Stock shall be 2 Coils of Part A , How shall I get the same result.

Pls Help/

Rajesh

[A S MANN]

Some clerification
In Coils Out Coils Bala Stock
10 3 7
10 5 5
Your balance is 7 + 5 = 12
What do you mean by
I want that Balance Stock shall be 2 Coils of Part A , How shall I get the same result
Calculation are simple but let me understand it fully.

[Demerit]

For Part A, 10-7 = 3 So what do you mean by 2 coils?