Help wth Filter Formula

1

Hi all!

I believe this is super easy but still can´t make it work.

Im building a very simple inventory management system, which has 2 tables
-Products (ID, Product Name, Actual Stock)
-Transactions (ID, Product, Type of Transaction, Qty)

I want to calculate the Actual Stock by filtering all transactions for that given product.

Ive tried with both, filter and LookUp formulas, but Im missing something. Here is what I´ve tried:
Transactions.Qty.Filter(Transactions.Product=thisRow.Product)

Here is the link to the doc:

Any help is much appreciated. Thanks!

2

Hi Joaquín,

You made a couple of small mistakes in the formula.

image
image1079×202 25 KB

  • You need to filter the Transactions table, but in your formula you are just filtering the quantity column, which only contains numbers and none of the parameters that you put within filter()
  • Transaction.Products contains rows from Products, but ThisRow.Product is a text, so that won’t work as expected either. Pay attention to the icons of the chips.

image
image570×141 9.73 KB

Hope this helps,

Pablo

3

Thank you so much Pablo!