Lookup value in report from a child table

I have a report running on a table containing our list of clients that needs to pull a list of values from a child table which contains order details for the clients. The values themselves will just be barcodes and I would like to use the lookup command to pull the corresponding product names from the product table.

The report has a START loop using this filter which identifies the correct clients who have had transactions within 30 days and we are pulling other fields for the report properlyโ€ฆ

<<Start: Filter(Client Profile, AND(ISBLANK([Date Offboarded]), OR(MAX([Related Sales Helpers][Date])>TODAY()-30,MAX([Related Specimen Counts][Date])>TODAY()-30)))>><<[Client]>>

[Related Sales Helpers] contains 1 or more transaction rows from the child table for each client.
I tried the below expression without the TEXT at first but I was getting a couldnโ€™t match list to text error. Adding the TEXT seemed to work but only returned the first value. Putting the Lookup expression within its own nested START: loop also returned an error.

<<LOOKUP(TEXT([Related Sales Helpers][Product Barcode]),โ€œProductโ€,โ€œProduct Barcodeโ€,โ€œProduct Nameโ€)>>

0 8 554
8 REPLIES 8
Top Labels in this Space