Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In our product we are able to give sales reps percentages of sales.
So, if a sale is made for $100, sales rep x may get 50% and sales rep y may get 50% of the sale.
It may even happen that each rep will get 100% of the sale. Since this is for commission purposes the client isn't worried about double dipping.
I'm getting incorrect results (larger numbers than I should)
Here is my expression:
SUM(Revenue * Rep_Percentage)
The weird thing is that all of the Rep_Percentage numbers are 1, so I'm not sure how I could screw up that expression.
Can someone give me an idiot check!
Thanks
Is commision fix to 50% in every salesperson?
No, it's all over the place. For example if there was a sale for $100:
Sales Rep X gets 75%
Sales Rep Y gets 25%
For another sale:
Sales Rep X gets 100%
Sales Rep Y gets 100%
They do this, because the revenue is used for calculating commissions.
Thanks,
I guess, you need to have tables like
Sales [Salesperson, Place, SalesAmount]
connect it to
Commision [Salesperson, Place, Commision Rate]
So that it's easier to identify the commision rate.
It's just an idea.