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
Ganpati Khot 4Ganpati Khot 4 

Please help me for below formula

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.

I am entering below formula:
IF( Contribution_Percentage__c <=10,"Low", 

IF(Contribution_Percentage__c >10 && Contribution_Percentage__c <40,"Medium", 

"High"))

Still its not working....can anyone please help me here?
Ganpati Khot 4Ganpati Khot 4
Getting below error:

 Error: Formula cannot use another formula field that directly or indirectly refers to itself. Opportunity.Contribution_Level__c -> Opportunity.Contribution_Level__c
 
CharuDuttCharuDutt
Hii Ganpati Khot
Try Below Formula 
IF( VALUE(Contribution_Percentage__c) <=10,'Low', 
IF(VALUE(Contribution_Percentage__c) >10 && VALUE(Contribution_Percentage__c) <40,'Medium','High'))
Please Mark It  As Best Answer If It Helps
Thank You!
Ganpati Khot 4Ganpati Khot 4
Hello CharuDatt, 
Thanks for the response!
Getting below error while checking syntax:
 Error: Incorrect parameter type for function 'VALUE()'. Expected Text, received Number
Ganpati Khot 4Ganpati Khot 4
Tried both the Formula getting this error: We submitted an opportunity and expected the Contribution Level to be Medium, but it wasn't. Check your formula in the 'Contribution Level' field.
Yash Verma 10Yash Verma 10
Try This Formula:-
IF( Contribution_Percentage__c <= 0.10, "Low",
IF( Contribution_Percentage__c > 0.10 && Contribution_Percentage__c < 0.40, "Medium",
"High")
)
somaraju macharlasomaraju macharla
Tq yash varma these formula is working