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
Brian MyersBrian Myers 

Advanced Formulas challenge error:The 'Opportunity_Progress__c' formula field does not exist or is not of type 'Number'

I am working on Level Up with Advanced Formulas.  The challenge indicates that you must create a formula that returns text values of either "Early", "Middle", or "Late".  When checking the challenge I am recieving a message that the formula is expecting a number,  Has anyone been able to pass the challenge and if so, would you mind sharing your solution?
Best Answer chosen by Brian Myers
Amit Chaudhary 8Amit Chaudhary 8
PLEASE check the FLS for same field. Make sure field should be visible to all and please use the same formula which i posted in above post
 

All Answers

Amit Chaudhary 8Amit Chaudhary 8
Please check below post for same issue
1) https://developer.salesforce.com/forums/?id=906F0000000MJIqIAO
2)https://developer.salesforce.com/forums/?id=906F0000000D8IDIA0

Percentage Completed field:
(DATEVALUE( CreatedDate ) - CloseDate ) / 100

Opportunity progress :
IF( Percent_Completed__c < 25 , "Early", 
IF(Percent_Completed__c >25 && Percent_Completed__c <75 ,"Middle","Late"))

Let us know if this will help you. If not then please share your field screen shot

 
Brian MyersBrian Myers
I am still receiving the same error.
User-added image

The formual API name is correct.
User-added image


If I modify the formula to return a number I still get the same error.

User-added image
 
Amit Chaudhary 8Amit Chaudhary 8
PLEASE check the FLS for same field. Make sure field should be visible to all

NOTE:- Your field API is wrong. You forget to add r in Progress.
Brian MyersBrian Myers
Thanks, I can't believe I missed that.  I checked that numerous times.  I correct the name hwever I still receiving the error.
User-added image
Amit Chaudhary 8Amit Chaudhary 8
PLEASE check the FLS for same field. Make sure field should be visible to all and please use the same formula which i posted in above post
 
This was selected as the best answer
Brian MyersBrian Myers
Challenge completed!  Your assistance is greatly appreciated!