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.