-
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!
Log In to reply.
Popular Salesforce Blogs
![Record-Triggered Flows](https://images.forcetalks.com/wp-content/uploads/2022/12/17101724/Record-Triggered-Flows.jpg)
Record-Triggered Flows in Salesforce - A Short Guide
Auto-launched flows in record triggers make additional updates after they are saved to the triggering record or database. One of the many different types of Flows…
![](https://images.forcetalks.com/wp-content/uploads/2024/03/21104741/sa_1711018036Boutique-1024x576.jpg)
What are the Common Challenges faced by Salesforce Consulting Firms in the USA?
In the realm of digital transformation and customer relationship management (CRM), Salesforce stands tall as a market leader. As businesses across the United States embark…
Popular Salesforce Videos
DreamTX Welcome Day 3: Customer Success | Dreamforce 2020 | Salesforce
If you missed DreamTX DAY 2, then live this amazing experience here, we have covered it all for you. Digital transformation requires more than just…
Learn About Types of Sandboxes in Salesforce
A sandbox is a copy of your organization in a separate environment that you can use for a variety of purposes, such as testing and training.…
Salesforce AppExchange Pricing Models
Salesforce AppExchange offers a wide range of solutions and applications designed to enhance and extend the functionality of Salesforce. However, understanding the pricing models can…