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

    Calculation

    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.