Skip to main content

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.

30 comentarios
  1. 6 jun 2023, 7:29

    IF( Contribution_Percentage__c < 0.10 , "Low" ,

    IF(

    AND(Contribution_Percentage__c >= 0.10, Contribution_Percentage__c <= 0.40),

    "Medium" , "High"

    ))

0/9000