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
Megs RamtekeMegs Ramteke 

: Field Label: Contribution Level Field Name: Contribution_Level Formula Return Type: Text Return values: Less than or equal to 10%: Low Between 10% and 40%: Medium More than 40%: High Hint: CASE s

Create a formula field that shows an opportunity’s progress:
Field Label: Contribution Level
Field Name: Contribution_Level
Formula Return Type: Text
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
VinayVinay (Salesforce Developers) 
Have you written any formula if yes can you post error of what do you see?

Thanks,
Maharajan CMaharajan C
Hi Megs,

Please try the below formula:
  
IF( Contribution_Percentage__c <= 0.10, "Low",
IF( Contribution_Percentage__c > 0.10 && Contribution_Percentage__c < 0.40, "Medium","High")
)

If Contribution_Percentage__c is percentage field,  then inside formula field you have to use 0.1 instead of 10%.


Thanks,
Maharajan.C