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

expressions
(Miranda Lubarsky) #1

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!

(Steven Coile) #2

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

(Miranda Lubarsky) #3

@Steven_Coile thank you steven! You are the master!

(Grant Stead) #4

@Miranda_Lubarsky Right Steven is getting nasty!

(Aleksi Alkio) #5

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