-
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
What are the Salient Features of Salesforce?
Salesforce is a noteworthy cloud computation organization that has practical experience in Customer Relationship Management programming. It offers a few outstanding items that are intended…
5 Reasons to Choose Salesforce for Non-Profit Organizations
Nonprofits are the healers of our society. They try to bring required cultural and judiciary changes for a better future. In the digital age, nonprofits…
Types of Collections in Apex Salesforce | Explained
In Apex, Collection is a group of individual objects represented as a unit (unit). Sometimes you need to group multiple items in a single unit.…
Popular Salesforce Videos
What Is Loyalty Management in Salesforce? | Video Tutorial
In the past few years, we have come across terms such as loyalty programs and loyalty management. Let's understand the concept of loyalty management with…
Salesforce Communities: 5 Powerful Ways to Drive Growth
Salesforce Communities are brand spaces designed specifically for Salesforce customers to connect with the community outside their org (i.e., employees, partners, and customers) and collaborate…
Get Rich Insights on Your Salesforce Users With Tableau | Did You Know
Did you know you can use Tableau to get rich insights on your Salesforce users? Login history, geo, browser, OS, and more are all at…
Popular Salesforce Infographics
Overview of Salesforce AppExchange Apps Market: Key Insights and Trends for 2024
The Salesforce AppExchange marketplace continues to expand, offering a diverse array of applications designed to enhance various business operations. Our 2024 analysis delves into the…
5 Salesforce User Adoption Quick Wins to Focus on Now
Salesforce user adoption is a funny business! To put it plainly, user adoption on Salesforce is just enabling a user to use it as the…
Here’s What Makes Up Salesforce’s Customer Base
Recently Mintigo took a close look at Salesforce’s customer data. Their analysis sheds some light on what their customers are up to and how the customers have…