So, I have a table called Picking. In this table I have an EnumList of invoice numbers coming from a Virtual column that has been split so that it can be properly indexed. I want to get the value from this EnumList so that I can look for it in a table called Invoicing. Now I am using the action, "Execute an action on a set of rows" from the Picking table to the Invoicing Table, and the referenced rows formula is as follows
The line in orange is not working, and that formula is not correct because I want it to single out the invoices that were picked in Enumlist and look for them in the Invoicing table
If there's a better way of achieving this, please let me know as I am stuck
Also, I have a looping action that converts Enumlist to Rows to a third table called Dispatching. I got that part to work.
here are the tables
Solved! Go to Solution.
I found the solution thank you
on the orange line, I ended up using
IN([Invoice Number],List([_THISROW].[Picked Invoice Number]))
I'm trying to follow this but finding it difficult. If you can try to explain the business problem you're trying to solve, it might help.
I found the solution thank you
on the orange line, I ended up using
IN([Invoice Number],List([_THISROW].[Picked Invoice Number]))
User | Count |
---|---|
17 | |
11 | |
7 | |
5 | |
5 |