0 Replies Latest reply on Feb 13, 2013 1:25 PM by NikosGewrgioy

    Calculation and Sum for all Records

    NikosGewrgioy

      Title

      Calculation and Sum for all Records

      Post

            

           Hello,

            

           I would like to make a relationship for sold items and for stock items to know how many items I have in stock.

           I have two fields one for Quantity Potentiometer and one for Type of Potentiometer.

           I make a calculation field with with name Sold 250k Pot with function: If (Pot type = "CTS 250k Audio Pot";  Quantity Pot) and then I have another one calculation which removes the Bought 250k Pot and I know how many Pots are in stock (Bought 250k Pot - Sold 250k Pot) and work perfectly but if I go to a new record the Bought, Sold and Stock fields didn't show me the remaining stock items or the bought parts or the sold parts from the previous projects.

            

           Could you help me to solve this problem?

            

           I have uploaded the database to Dropbox to show you the problem.

            

      http://www.dropbox.com/s/fo6f8qcbfq0b1e4/Projects.fmp12

            

           Thank you in advance