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”)>>