-
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
How to Update the Values of a Custom Picklist Field using Metadata API?
The user can easily add, delete, or update the values of a custom picklist field manually. But there are times when you have to update and…
Salesforce For Email Marketing: Interview with Mar Tech expert
Marketing Cloud provides an expansive range of tools that can be used for different types of customer engagement processes. One of them is Email Studio.…
Getting Started with Salesforce Lightning Components and Record Pages
What energizes me most about Lightning Experience is the adaptability of the UI. With its module structure, and the capacity to dole out pages at…
Popular Salesforce Videos
Salesforce Multi-factor Authentication/Two-factor Authentication End User Training Video
Watch this video to learn all about Salesforce Multi-factor Authentication/Two-factor Authentication. This is a training video. Watch and learn.
Multipurpose VF Component to Add Multiple Records on a Button's Click | Salesforce Tutorials
In this video, I will create a multipurpose VF component to add Contact records in a list on the click of a button then I…
Dreamforce 2019 - An Overview!
Salesforce Dreamforce2019 is scheduled for November 19-22 in San Francisco, California at the Moscone Center. #Dreamforce is one of the largest cloud and SaaS-centric conferences…
