Calculating Total Inventory

[Guest]

Hello,

I have 4 columns that contains inventory in 4 warehouses. I want to add a
column that will calculate the total inventory per SKU (line) for all
warehouses.

My query is like this:

"SKU" "WAREHOUSE1" "WAREHOUSE2" "WAREHOUSE3" "WAREHOUSE4"

and I want the total inventory per sku.

I tried using TOTAL INVENTORY:[WAREHOUSE1]+[WAREHOUSE2]+ . . . but I find
out that it add the field name, not the quantity that represents the field
name.

Any input will be appreciated.


Regards

Stephan

 

[Guest]

Change your table to like this --
Item - text
Location - text
Qty - number

The data would look like this --
Item Location Qty
SKU Warehouse1 15
SKU Warehouse2 4
SKU Warehouse4 52
SKU Warehouse3 1
SUX Warehouse1 10