When there is only one sales rep, I can easily edit the report and put in a commission calculation and search by that sales rep.
However, the problem comes when there is 2 or 3 sales reps, as you can see they seem to be seperated in the field “SalesReps” by a squiggle symbol.
Ideally, what i need is the BAQ to sort by each individual sales rep to say what their commission is in a specific period…It would be easier if it seperated each rep on a seperate row.
While our BAQ is a little more complicated because we use bookings as one of the commission ingredients, here’s the link for OrderHed to SalesRep which will give you one record for each sales rep on an order.
