0 Replies Latest reply on Oct 11, 2015 7:42 PM by thong127



      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.