-
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
A Brief Guide For Salesforce Developers To Understand Customer Data Platforms (CDPs)
Have you realized data’s powerful aspects, or are you in the process? Data is the new king here, so those who own it can multiply…
What are Salesforce Flows? | All You Need to Know
Salesforce Flows Salesforce Flow, formerly known as Visual Workflow, is a cloud-based automation tool provided by Salesforce. It allows users to create and automate business…
How to work with Salesforce1 Navigation Menu?
Hey guys, Everyone knows what is Salesforce1? But if you don’t know then I will define for you. Salesforce1 is a mobile app for Android,…
Popular Salesforce Videos
What are The Benefits of Salesforce Financial Services Cloud?
Business today is all about relationships. That’s nothing new. But how you go about managing and maintaining those relationships is completely different in today’s business…
Data Import: Clean and Prepare Your Data Using Excel | Salesforce
Cleaning and Preparing Data Using Excel covers several features and functions that will make quick work of getting your data files ready for import. Vlookup,…
Create a LinkedIn Page like a Salesforce Professional
In this first video of our series "How to Find a Job as a Salesforce Professional", Brad discusses how to create and modify your outdated…
Popular Salesforce Infographics
In marketing, Can We Achieve What We Can’t Measure? | Salesforce
Metrics in marketing are always evolving and we can all learn more about them from our peers. Let’s look at where marketers are spending their…
How to Select A Cerified Salesforce Administrator?
Once you implement Salesforce, one of the most important ways to stay successful is to designate an incredible Salesforce Administrator. Easier said than done, right?…
Key Differences Between Salesforce Sales Cloud and Service Cloud
𝐂𝐡𝐞𝐜𝐤 𝐨𝐮𝐭 𝐭𝐡𝐢𝐬 𝐢𝐧𝐬𝐢𝐠𝐡𝐭𝐟𝐮𝐥 𝐢𝐧𝐟𝐨𝐠𝐫𝐚𝐩𝐡𝐢𝐜 𝐜𝐨𝐦𝐩𝐚𝐫𝐢𝐧𝐠 𝐒𝐚𝐥𝐞𝐬𝐟𝐨𝐫𝐜𝐞 𝐒𝐚𝐥𝐞𝐬 𝐂𝐥𝐨𝐮𝐝 𝐚𝐧𝐝 𝐒𝐞𝐫𝐯𝐢𝐜𝐞 𝐂𝐥𝐨𝐮𝐝! Dive into the key differences between these two powerful Salesforce solutions: Focus and…
