I have two tables
Materials Table and History Table
In my Materials Table I Have the Following fields
Quantity in Hand
Can you please help me find the right formula on how to calculate my Material Balance.
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.