-
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 Marketing Cloud: Your One-stop Marketing Solution
The Word-class CRM solution, Salesforce does not leave any room for doubts and connects brands and customers in the best possible way. With multiple cloud…
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…
Learn All About Platform Events in Salesforce | The Developer Guide
Platform events are based on an event-driven architecture for delivering secure, extensible, and customizable notifications in Salesforce or external applications. This is a real-time integration…
Popular Salesforce Videos
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…
Apex Scheduler in Salesforce | Asynchronous Apex
Asynchronous Apex 1. Apex Scheduler 2. Interfaces in Apex Scheduler 3. Making callout using Apex Scheduler 4. Points to Remember Upcoming Video on How to…
How to Get A Part Time Salesforce Job
In this video, Brad discusses different techniques to convince a potential employer to offer you a part-time Salesforce position. This job option allows for additional…
Popular Salesforce Infographics
A Four-step Formula for Salesforce Implementation
No matter how big or small your company—or the Salesforce CRM project—success requires planning, commitment, and strong sponsorship from your company’s executive team. It’s also…
Salesforce Agentforce - The AI assistant for business growth
This infographic highlights Salesforce Agentforce, an AI-powered assistant designed to enhance business growth through automation, insights, and intelligent task management. It explains how Agentforce transforms…
How to Navigate a Successful Salesforce Implementation
There are many ways to navigate a Salesforce implementation. Check out this infographic to learn how to do it successfully.
