SUM (I get get this to work)
this is so simple, but I can't seem to make it work!
Table = Product
Field = Inventory_QTY this is received inventory placed in a warehouse location
We receive inventory and place it in an empty location in the warehouse. therefore we may have the same SKU number in multiple locations. i need to know how many total for that SKU#
We have a SKU number field = SKU
I made a relationship = Product Self_SKU#
I made a field called = Amount_in_stock = calculating field , calculating result is Number
The function is: Sum (Product Self_SKU#::Inventory_Qty)
I know I'm probably doing something stupid, can you help?