-
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 -
0 Replies
Log In to reply.
Popular Salesforce Blogs
The Growing Importance of Data Privacy in Software Development
A shared concern in today’s society especially for the new age companies and consumers as well as the government performing their duties is data privacy.…
Formula Fields and Roll-up Summary Fields Usage in Salesforce
Here We are going to discuss “Formula Fields and Roll-Up Summary in Salesforce”. Let's talk beforehand about my blog. Formula field: We use Formula Fields…
Send Email to Salesforce Sales Cloud Data from Marketing Cloud Using Import and Automation Filter Activity
Go through this blog to have a better understanding of how import and automation filter activity works in Salesforce Marketing Cloud. Requirement: We want to…
Popular Salesforce Videos
Rollup Trigger via Salesforce Record Triggered Flow - Trigger without code
Hello Folks, I created a Rollup trigger via Salesforce Record Triggered Flow (without code cool isn't). I use Record trigger Flow for that scenario. There…
Salesforce Visualforce and Force.com Development Tutorial || Beginner
Learn to set up a web page using force.com and create forms for users to input information into Salesforce. For more Salesforce tips and tricks…
Practice Test and Questions for Salesforce Platform App Builder Certification Exam
In this video, Shrey provides a practice test for the candidates who are preparing for the Salesforce Platform App Builder Exam. This test boosts your…
Popular Salesforce Infographics
How to Handle Failed Salesforce AppExchange Security Review?
Common reasons for a ‘FAILED’ Salesforce AppExchange Security Review The most common reasons for failing a Salesforce AppExchange security review can vary, but they often…
Buy vs. Build: Salesforce Shield: Event Monitoring
Today, businesses store their most confidential information in the cloud with applications such as Salesforce. This means dozens, hundreds, or even thousands of employees have…
Top 10 Salesforce Consulting Companies in India
Looking to hire a best Salesforce consulting company in India for your business? Here is a without-favour list of the top 10 Salesforce consulting companies…
