Apex Code Development You need to sign in to do that
Don't have an account?
franklin_atx Formula Failure
Need help with this as I've never had a formula that needed to look across values (< >).
IMAGE (CASE (Total_Score__c,
">= 104","/img/samples/stars_500.gif",
"<=103 >=78","/img/samples/stars_400.gif",
"<=77 >=52","/img/samples/stars_300.gif",
"<=51 >=27","/img/samples/stars_200.gif",
"<=26","/img/samples/stars_100.gif",
"/img/samples/stars_000.gif"),
"rating")
The error I receive is that the formula is too long. I've taken it down to just one line and it works but I can't get it to pass with all lines.
works
IMAGE (CASE (Total_Score__c,
">= 104","/img/samples/stars_500.gif",
"/img/samples/stars_000.gif"),
"rating")
This is the error I receive: Error: Compiled formula is too big to execute (11.104 characters). Maximum size is 5.000 characters
I'm guessing "Total_Points__c" is also a formula field? You have to keep in mind that formulas are cumulative. So if "Total_Points__c" is a large formula, it will push your new one over pretty quickly.