-
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
Finding the Best Salesforce Consulting Partner: Your Guide to Success
In today's competitive business landscape, organizations across industries are leveraging the power of Salesforce to streamline operations, enhance customer relationships, and drive growth. However, maximizing…
Raspberry Pi - Turning Lights on and off Using Relay Board
In this post, we will be learning about connect 4 Channel relay board to Raspberry Pi. What is a relay? A relay is an Electrical…
Case Management: Email-To-Case | The Salesforce Developer Guide
Case Management Case Management means gathering all the client/customer cases into one place and ensuring they go to the right person, for the resolved cases,…
Popular Salesforce Videos
Salesforce Einstein Search
Salesforce Einstein Search makes your users more productive by bringing the power of Einstein and AI to Salesforce Search. Einstein Search is Personal, Natural, and…
Journey To A Salesforce Solution Architect
A Salesforce Solution Architect must master a number of skills to be able to solve complex business requirements. In this session, we will cover 10…
How to Use Salesforce for Project Management
When you think of CRM software, "Salesforce" is probably one of the first words that comes to mind. But Salesforce can do so much more…
