AnsweredAssumed Answered


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.