Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
MOHAMMED BABAMOHAMMED BABA 

Hi Team, Please help on the below request i am getting confuse which tool and what is the procedure have to use.

  1. Create a new field (Commission) on Opportunity object and it should automatically calculate the commission based on the below conditions:
  • If Lead Source is Web and Amount is greater than 1,000 then the commission is 2% of the Amount.
ANUTEJANUTEJ (Salesforce Developers) 
Hi Mohammed,

https://help.salesforce.com/articleView?id=useful_advanced_formulas_commission.htm&type=5

As mentioned in the above article there are sample commissions formula fields that you can try checking.

Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.  

Thanks.
MOHAMMED BABAMOHAMMED BABA
Hi Anutej,, Thank you for your reply but I couldn't get exactly which formula I have to use ,it would be better if you give me exact formula to use in the formula field
Akshay Shirkar 17Akshay Shirkar 17
Hi Mohammed,

The Exact Formula for your requirement is as follows.

IF(AND( ISPICKVAL(LeadSource,'Web'),Amount >1000), ((Amount*2)/100), 0)

The formula is tested successfully. Just let me know whether its completing your requirement or not.

Regards,
Akshay Shirkar