0 Replies Latest reply on Feb 8, 2016 2:32 PM by trustedworld

    New to Filemaker formula/calculation/scripts

    trustedworld

      Hey!

       

      I am using the starter Inventory solution with some modified fields.  I want to do a calculation but I am not sure if it is a script a calculation or how to approach this.  in addition to he basic solution I added a location table which you can assign the stock locations to.  This seems to work fine, however i want to know what is in each location and have it displayed by location in a field.  In my head I see the formula as this

       

      Sum (Units In where location = Warehouse)

       

      I am not sure what I need to do in order to make this work.

       

      Any suggestions?