-
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
Salesforce Skills Needed To Get Hired In Top MNCs
Need to find a superior employment option in 2018? If your answer is yes then there is one thing that you need to complete in…
Value of Salesforce in Small and Medium Business
Speed is the quintessence of the business world. That is valid for almost every part of our business, yet it's particularly valid for innovation and…
ChannelOnline To Salesforce Integration Setup [EPISODE -2]
Integration Setup In Salesforce Resellers must perform the following setup steps in Salesforce in order to exchange data Enable the correct employee for use with…
Popular Salesforce Videos
Salesforce Data Archive along with Files
This video tries to explain the way true archive of records as well as the files in Salesforce. Archive files along with the DataArchiva, We…
Salesforce CPQ from Scratch
CPQ Salesforce, or Configure, Price, Quote Software by Salesforce is a sales tool for companies to provide accurate pricing with any given product configuration scenario.…
Salesforce Vaccine Cloud
Salesforce is launching Vaccine Cloud, a set of tools to enable government and healthcare organizations to manage and deploy COVID-19 vaccination programs. Vaccine management has…
Popular Salesforce Infographics
6 Tips to Evaluate the Right Salesforce QA Vendor
Salesforce is the ultimate customer success platform, which makes it important to choose the right partner for your Salesforce project especially because it governs your…
What are Salesforce Lightning Web Components?
Lightning Web Components ( LWCs ) are User Interface (UI) framework and utilized for creating applications with desktop and mobile technologies. This framework acts as…
How Salesforce is Beneficial For Your Business
There is a saying frequently heard many times which is “ Customer is a King”. So, a business needs to do everything to satisfy the…