Hi, I'm working with Level Up with Advance formula on a Advance Formula Module.
I have checked the formula I have used on the playground and getting my desired result.
I am getting: We submitted an opportunity and expected the Contribution Level to be Low, but it wasn't. Check your formula in the 'Contribution Level' field.
When I created an Opportunity, I am getting my desired result. Is it me or I just didn't understand the challenge?
The challenge is: Create a formula field that classifies an Opportunity by the size of its contribution to an individual quarterly target.
I have created Contribution Percentage field and has this formula:
ExpectedRevenue / 100000
and created Contribution Level field and has this formula:
IF( Contribution_Percentage__c > 0.40, "HIGH", IF( Contribution_Percentage__c > 0.10, "MEDIUM", "LOW") )
*****
I've been working on it for days. Help. Thanks.
IF( Contribution_Percentage__c < 0.10 , "Low" ,
IF(
AND(Contribution_Percentage__c >= 0.10, Contribution_Percentage__c <= 0.40),
"Medium" , "High"
))