I’m creating a BAQ that lists out InvcDtl rows. I need to get a RowCount for all InvcDtl rows for this InvoiceNum that have a PartNum that starts with 2 characters and ends in a specific character as this defines which commission rate needs to be applied (1-10 = Rate1, 11+ = Rate2, etc) to the extended price for this row.
I’m having trouble getting this info. I’m not sure if I need to use an InnerSubQuery and then link it to the my first query or if this can be handled in CalculatedFields?
I’m running into " Possible unauthorized query" in both cases.
Thank you in advance for your time and effort.