I was hoping for some help with creating a report to calculate our comission payouts. Here is how the commission is broken down:
Month 1 of close (closing month): 50% of TotalPrice
Month 2 of close : 40% of TotalPrice
Month 3: 30% of Total Price
Month 4: 20%
Month 5: 10%
End
If Opportunity Stage is not Closed Won, then it will no longer calculate. So if client cancels month 3, commission ends immediately.
I am having a hard time sorting by rep, and also by month. So what I need it to do is total all opportunity products closed in month 1 to show 50% of on the report then 40% of month two etc.
Any ideas? Thanks.
2 answers
Would that be something easy to do? There is no way to include something like this in SF?
