donnarenia
Technical User
This one may be a bit hard to explain.
I created a commission report that shows the Salesperson 1 and the following information: Invoice Date/Aged Months/Client Name/Invoice #/Invoice Amount/Commission Rate/ Commission Amount
This report works fine. Now I have added a Salesperson 2 and want the same information EXCEPT a different commision rate.
Have duplicated my formulas so I can get the information I want however i am getting duplicate data when I run my report. I added the Salesperson 2 information in to details b and I can see the one instance where Salesperson 2 is correct but I don't want to see it repeated, ONLY Unless there is a Salesperson 2.
My question is how can i get Salesperson 2 information to show only if a second salesperson is entered?
I created a commission report that shows the Salesperson 1 and the following information: Invoice Date/Aged Months/Client Name/Invoice #/Invoice Amount/Commission Rate/ Commission Amount
This report works fine. Now I have added a Salesperson 2 and want the same information EXCEPT a different commision rate.
Have duplicated my formulas so I can get the information I want however i am getting duplicate data when I run my report. I added the Salesperson 2 information in to details b and I can see the one instance where Salesperson 2 is correct but I don't want to see it repeated, ONLY Unless there is a Salesperson 2.
My question is how can i get Salesperson 2 information to show only if a second salesperson is entered?