AnsweredAssumed Answered

Calculation

Question asked by thong127 on Oct 11, 2015

I have two tables

 

Materials Table and History Table

 

In my Materials Table I Have the Following fields

 

Quantity Received

Quantity Used

Quantity in Hand

 

History Table

 

Quantity Dispensed

Quantity Returned

 

Can you please help me find the right formula on how to calculate my Material Balance.

 

For example

 

If I have a 20 Kg Received ; then they Dispensed 5 Kg, Then My Quantity return will give me 15 Kg ;

 

The formula that I'm using to find my Quantity on Hand is

 

If ( IsEmpty ( Sum ( History::Units In ) - Sum (History::Units Out ) ) ; 0 ; Sum ( History::Units In ) - Sum ( History::Units Out ) )

 

The result is not matching with my Quantity received.

 

Any help is appreciated.

 

Thank you.

Outcomes