-
Formula Syntax for Percentages dependent on picklist values
Hello! I need some assistance with a formula I am trying to create.
Here are the fields and variables I am working with:
Picklist 1 = List of Names
Picklist 2 = List of Names
Percentage 1 = %
Percentage 2 = %Basically here is what I would like the formula to do for the field Percentage 2...
If the value for "Picklist 1" = "Picklist 2", then "Percentage 2" should receive the same value that was input for "Percentage 1". If not, the value for "Percentage 2" should be set to 0.00%.Here is what I have and the error I am getting:
IF("Picklist_1__c" = "Picklist_2__c", "Percentage_1__c", 0.00)
Error: Incorrect parameter type for function 'IF()'. Expected Text, received Number
Log In to reply.
Popular Salesforce Blogs
Introduction to Exception Handling in Salesforce Apex
Whenever you use a controller extension, extending a standard object, you can use the getRecord() to get the reference to the record. Most of us…
Wrapper Classes in Salesforce | Here's What You Need to Know
Apex Wrapper Classes are custom classes in Salesforce that are used to hold one or more primitive data types as members. This allows for encapsulating…
Co-Create Success With the Changing Salesforce Ecosystem
The Salesforce partner community is a powerful force. It is a place where Salesforce partners manage their business, learn best practices, get support on projects,…
Popular Salesforce Videos
Salesforce Flow to Create Feedback form on Case | How to use Slider, Radio button on Screen Flow
Use Case: In this video, we are creating a screen flow to get feedback from the users when the case is closed. Learnings: 1. How…
How To: Build A Salesforce Career with This Tool!
Timecodes 0:00 - Intro & Overview 0:57 - Talent Stacker 3:00 - Career Progression 10:08 - Flow is the Future 13:36 - Learn More/Outro If…
All About Public Group in Salesforce
Public Group represents a custom group of users defined by an administrator. Users can be added to a public group individually, or based on their…
Popular Salesforce Infographics
4 Reasons To Offer An Exceptional Customer Service
When it comes to customer service, our friends at Salesforce have a few tips and tricks up their sleeve. We were thrilled to help them…
5 steps to follow for successful Salesforce Implementation
Although implementing Salesforce is designed to help you meet the challenges of your business, it might not provide the results you want, whether it is…
Infographic: 3 Trends That’ll Transform Small Business Growth in 2018
If you’re hoping to successfully grow your small business this year, you need to stay on top of the newest trends. Not sure where to…