AnsweredAssumed Answered

SUM (I get get this to work)

Question asked by dansan500 on Feb 17, 2015
Latest reply on Feb 17, 2015 by philmodjunk


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?