+ Start a Discussion
Rahul456Rahul456 

Compare picklist field value with a text that conatins special characters

Hello,

 

        I have CASE function in my forumla field where I am checking this picklist field value with a text that contains special characters.Eventhough this picklist is holding the same as text value at salesforce record but the else part in CASE is getting executed.

 

CASE( PricebookEntry.Product2.Product_Category__c ,"KONE Alta & MiniSpace > 3.5 m/s",82,81)

 

In above the formula criteria Product_Category__c holds the "KONE Alta & MiniSpace > 3.5 m/s" value but I am getting 81 as result where I am expecting 82.