-
How to create Formula Field on Opportunity in Salesforce?
Hi all- been a while since I constructed one of these and wanted to get some help- On the opp object, looking to create a formula field based on 2 fields- Amount & License_Period_months__c ( A number field type).
Here's what I'm trying to accomplish:
If
License_Period_months__c = 12, Amount
If
License_Period_months__c = 24, Amount * 2 * .15
If
License_Period_months__c = 36, Amount * 3 * .30
I'm screwing up the IF statements here and getting errors. Can I get some advice on how you'd construct this to get the right amount? And would the field formula type be Currency? thanks!
-
1 Reply
-
Hello Elizabeth,
My solution is:-
IF(License_Period_months__c = 12, Amount, IF(License_Period_months__c = 24, Amount * 2 * .15, IF(License_Period_months__c = 36, Amount * 3 * .30, 0) ) )
Thanks.
Log In to reply.
Popular Salesforce Blogs
The ABC's of Salesforce - All you Need to Know
When you’re new to Salesforce, it’s easy to get lost in the lingo. There’s just so much information to digest that it can be overwhelming…
Step by Step Guide for Salesforce Knowledge Implementation
Salesforce Knowledge management capability provides the ability to solve multiple queries or incidents by providing the knowledge base by using articles. This can be utilized…
Salesforce Marketing Cloud and Pardot IP Warming Best Practices 2021- Improve Email Deliverability
IP warming isn’t a term you hear around the water cooler or marketing webinars. But it is important and any marketer who relies on email…
Popular Salesforce Videos
Explain Standard Business Features of Salesforce?
Standard business features of Salesforce are Contact Management, Opportunity Management, Lead Management, Quote Management, Sales Management and Sales Forecasting. Watch the video to learn all…
Invoke a Salesforce function from Apex
Learn about the different ways in which you can invoke a Salesforce. Watch this video and learn, if you have any doubts or concerns, do…
Salesforce Workflow vs Process Builder | Salesforce Tutorial
This "Salesforce Workflow vs Process Builder" video by Edureka will firstly help you understand what exactly is Salesforce workflow and what is Salesforce process builder.…
