Background
I have an Order which lists Ordered Kits and Ordered Products. A kit contains a pre-defined list of parts derived from products. A Kit is ordered at the Kit level and when saved, a workflow populates the list of parts into the Order Products table. It may be that not all parts need to be ordered so they can be removed from the Order Products list. AND it may be that other parts are ordered and included in the Ordered Products list.
Invoicing
On the invoice I want to show:
This means I need to split the Related Ordered Products by each Kit ID and then where ISBLANK(Kit ID)
Question
In example template expression excerpt below, is there a way that [Kit] can be referenced from the outer Start row within the inner Start expression? The text is red obviously doesnโt work since it references the Order row used to generate the invoice.
User | Count |
---|---|
19 | |
10 | |
7 | |
5 | |
5 |