function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Hiral Patel 25Hiral Patel 25 

Return values: Less than or equal to 10%: Low Between 10% and 40%: Medium More than 40%: High

I want solution for this

Return values:
Less than or equal to 10%: Low
Between 10% and 40%: Medium
More than 40%: High

Hint: CASE statements can’t contain Boolean functions. Use IF statements instead.
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Hiral,

Are you looking for a formula field based on the percentage the values should be Low,Medium or Hight.

Thanks,
 
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Hiral,

Please use the below formula.
  
if( percentage__c <=0.1,'Low',if( AND(percentage__c>0.1,percentage__c<=0.4),'Medium',If(percentage__c >0.4,'high','') )

 )

If this solution helps, Please mark it as best answer.

Thanks,

 
CharuDuttCharuDutt
Hii Hiral
Try Below Formula With Data Type Text 
IF( percentage__c <=0.1,'Low',IF( AND(percentage__c>0.1,percentage__c<=0.4),'Medium',IF(percentage__c >0.4,'high','')))
Please Mark It As Best Answer If It Helps
Thank You!