-
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
12 Tips To Consider Before Implementing A CRM System For Your Business
There is a much fuss about the CRM systems across the IT and cloud managing services. Everyone is trying way too hard to keep up…
Move Towards A Subscription-Based Business Model | Salesforce Guide
Subscription-based business models have grown significantly over the past few years. In fact, Forbes states that eCommerce-based businesses used this model and doubled their growth…
New URL Format For Salesforce Lightning
This post taks about the upcoming new URL format for Salesforce Lightning experience ans Salesforce mobile. The new URL format will be available to users…
Popular Salesforce Videos
Introduction to Salesforce Commerce Cloud for Developers
Commerce Cloud powers e-commerce for many of the world's leading brands and it represents a great opportunity for developers around the world. Join us to…
How to Choose Salesforce Career Path | How To Start a Salesforce Career
With most of the businesses using Salesforce finding access to talent to be a ‘critical challenge’, it’s no wonder so many people are choosing a…
Learn Apex Triggers Part 2 in Salesforce Development
In this video, we will learn about Apex Triggers in Salesforce development: We'll will be discussing the following things in this video: 1. What are…
Popular Salesforce Infographics
Enhance Customer Experience With Salesforce
Salesforce Makes Personalized, Consistent Digital Customer Experience a Reality. Salesforce, widely recognized as the leader in business CRM, gives organizations the tools they need to…
DreamOle Event - Salesforce
A group of volunteers within the Spanish Salesforce Trailblazer Community. Their Mission is to put together a Community Conference that would help the Spanish Community…
How to Integrate Salesforce with External Systems
Salesforce Connect empowers you to associate Salesforce to external heritage frameworks like Oracle, SAP, DB2, Microsoft SharePoint continuously, without making a duplicate/copy of any single…