Display the invoice number with the largest number

[LarsonSolutions (Bruce Larson)]

Instead of showing just the maximum invoice number.
Why not a list of them?
Enter this as a NChar type calculated field on the BAQ.

STRING_AGG(InvcHead.InvoiceNum, ', ')

@NateS offered this in another post.

Help with Consolidating Column Values in a One-To-Many Table Relationship

Hi Tony, I think you can make this work with the String_Agg() function. You can create a customer BAQ with the CustomerDocs inside the String_Agg. Use it in a calculated field expression like this: String_Agg(OrderHed.OrderNum, ', ') Make sure you group on your customerID, and your aggregated string should return all the docs they have listed. Now if you want to break that string agg up into individual check boxes, that is another step. Create calculated fields for each document check box (8…