-
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
Avoiding Common Hiring Mistakes When Recruiting Salesforce Developers
In today's rapidly evolving digital landscape, Salesforce has emerged as a powerhouse CRM platform. It enables businesses to manage customer relationships efficiently and drive growth.…
Learn All About the Apex Core Concepts in 2023
Apex code typically contains many things that you might be familiar with from other programming languages. Programming elements in Apex This Image will describe the…
Popular Salesforce Videos
Which Objects are in the Salesforce Sales Cloud and Service Cloud?
Salesforce comes with a large number of standard objects that are integral to Salesforce, but you can also create custom objects. We’ve compiled a list…
Marketing Automation with Salesforce Journey Builder
Marketing Automation which is future of marketing can be simply understood as automating your marketing communication programs. we are going to talk about Salesforce Journey…
Data Loader Alternative | Export and Import Data Using Salesforce Inspector
Find out how to export and import data using Salesforce Inspector, a very useful alternative to traditional data loader. watch this video and learn all…
Popular Salesforce Infographics
Salesforce Events of 2018 | Infographic
Complete Salesforce Event Timeline for 2018 including Dreamforce, Salesforce World Tour and the Dreamin' events from all over the world. Use those links to connect…
Salesforce – A Key For Your Industry Solutions
Salesforce endlessly improves the productivity and performance of the company. To enhance the customer experience and generate more revenue in 2018 many industries will be…
Sneak Peek: Latest Features And Updates of Salesforce commerce Cloud
Here is an infographic of the Latest Features And Updates of Salesforce commerce Cloud