For example, if an employee sells under 4999.99 dollars per month, they recieve 0% commission.
If they sell between 5000 and 7999 dollars per month, they receive 10% commission.
If they sell between 8000 and 9999 dollars per month, they receive 20% commission.
If they sell 10,000 dollars plus per month, they receive 25% commission.
I am aware that i need to set this up as a formula on my opportunity reports but can anyone point me in the right direction of the formula...
Thank you!
7 answers
Try this
IF(Opportunity.YOUR_FIELD__c:SUM<8000, Opportunity.YOUR_FIELD__c:SUM / 10,IF(Opportunity.YOUR_FIELD__c:SUM<10000, Opportunity.YOUR_FIELD__c:SUM / 5,
Opportunity. YOUR_FIELD__c:SUM / 4 ))
