Hi,
I need to get jet to pull all the values related to work orders posted in the item ledger (Nav). I have linked the item ledger to the capacity ledger via order # and I need to pull all the Routing operation #s related to each work order. Some work orders have 6 rows of related data (Possibly expanding in the future) And I am only able to pull the first operation value (See image below for more detail).
Thanks.
Are you using a NL(Row...) for the Order No.? You could try NL(Rows=2 and populate the Field with Order No. then copy that value to the second row and that is where you would do the NL(Row...) formula for the operations.
If you could show your actually formulas, that would help to troubleshoot this further.
Are you using a NL(Row...) for the Order No.? You could try NL(Rows=2 and populate the Field with Order No. then copy that value to the second row and that is where you would do the NL(Row...) formula for the operations.
If you could show your actually formulas, that would help to troubleshoot this further.
Hi Dee,
I was able to figure it out awhile ago doing something similar to what you are suggesting. The only problem is that it is really slow using NL(rows and my preference is to use the NL(Table so that I can automatically format it with slicers in power query.
Thanks,
