-
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

Difference Between ERP and CRM – Salesforce CRM
Salesforce is a distributed computing administration as a product organization (SaaS) representing considerable authority in client relationships with executives (CRM). Salesforce administrations empower organizations to…

All you Need to Know About No Code Salesforce and Aircall Integration
If you're looking for a way to improve your customer service and sales process, you should consider integrating Aircall with Salesforce. Aircall is a cloud-based…

CSV Files in Salesforce | Data Import | How-to Guide
Data Import: Clean and Prepare Your Data Using Excel, Data Import: Clean Up Your Import File Learning Objectives Data Import: Clean and Prepare Your Data…
Popular Salesforce Videos
5 Pillars of a Successful Salesforce DevOps Process
Looking to improve your release and issue resolution times using Salesforce DevOps methodologies? DevOps is a software development and delivery process enabling seamless collaboration between…
Salesforce Validation Rules - Keep your Data Clean
Watch this short video for just over 2 minutes and learn how to keep your Salesforce data clean? The answer is simple: Use field validation…
Salesforce Spring 22 Treasure Hunt for Flow | Migrate your Workflow Rules to Flows
Salesforce Spring 22 Treasure Hunt for Flow 0:00 Register for pre-release org 0:27 Flow Trigger Explorer 2:07 Auto-Layout and Freeform option as Picklist 3:00 Set…