I would like to sum the inventory I have by location

[Vanis]

Hi all!

New to appsheet and I am creating an inventory app where I want to sum my inventory by location. At the moment when you go to the item detail, it sums the total items I have in the 2 warehouses, but i want to see how many stock I have in each wharehouse.

I have this:

IF(Inventory[Location]=“Warehouse1”,
SUM(
SELECT(
Inventory[Amount],
([Item ID] = [_THISROW].[Item ID])
)
)
)
but it gives me Cannot compare List with Text in (Inventory[Location] = “Warehouse1”), anyone knows how i can filter by location please?

Thank you!

[WillowMobileSys · Accepted solution]

Vanis:

anyone knows how i can filter by location please?

You would want to use the Location column in your SELECT like so:

SUM(
  SELECT(
    Inventory[Amount],
      AND([Item ID] = [_THISROW].[Item ID],
          [Location] = "Warehouse1")
  )
)

…And Welcome to the Community!

[Vanis]

OMG thank you so much, that worked beautifully! Glad to be part of this community