Hello all! I need help with an expression. ...

Hello all!

I need help with an expression.

I have a new table with a row referencing [Plant ID] which is the key in two of my other tables.

I would like to create a formula that adds up the value of Design Reorganization Table[# of plants] when the [Plant ID] in that table is equal to the value of the [Plant ID] in the new form I am creating (which the user selects in a drop down menu that is a ref to a different table).

Design Reorganization Table has many rows with the same Plant ID, so I am trying to get it to add them all up (Ie. SUM)

It seems this is easy if the Plant ID were to stay the same.

Then I could specify โ€œCarrots Yayaโ€.

But I would like the Plant ID value to be able to change, depending on what the user selects.

Ideas?

I donโ€™t think Filter or Lookup are going to work here because they need that specific text, not a ref to the value of a Column.

But maybe Iโ€™m wrong?

Thanks for the help!

0 4 304
4 REPLIES 4

sum(select(Design Reorganization Table[# of plants], in([Plant ID], list([_thisrow].[Plant ID]))))

@Steven_Coile thank you steven! You are the master!

@Miranda_Lubarsky Right Steven is getting nasty!

Do you have a virtual refrows column in this table and ref column in this Design Reorganization Table?

Top Labels in this Space