AnsweredAssumed Answered

New to Filemaker formula/calculation/scripts

Question asked by trustedworld on Feb 8, 2016



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?