AnsweredAssumed Answered

New to Filemaker formula/calculation/scripts

Question asked by trustedworld on Feb 8, 2016

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?

Outcomes