You need to sign in to do that
Don't have an account?
Guru Vemuru 1
Formula for insert Image?
Hi every one,
I written one formula for displaying images for different condition.
IF( Total_Lead_Score__c<20, IMAGE('/resource/1502342615000/Star1', 'Star1'),
IF( Total_Lead_Score__c<40, IMAGE('/resource/1502342589000/Star2', 'Star2'),
IF( Total_Lead_Score__c<60, IMAGE('/resource/1502342560000/Star3', 'Star3'),
IF( Total_Lead_Score__c<60, IMAGE('/resource/1502311560000/Star3', 'Star4'),
IMAGE('/resource/1502342499000/Star5','Star5')))))
This produces a Compiled formula too big error
CASE( Total_Lead_Score__c ,
Total_Lead_Score__c<20,IMAGE("/resource/1502342615000/Star1"),
Total_Lead_Score__c<40,IMAGE("/resource/1502342589000/Star2"),
Total_Lead_Score__c<40,IMAGE("/resource/1502377589000/Star3"),
Total_Lead_Score__c<40,IMAGE("/resource/15023222000/Star4"),
IMAGE("/resource/1502342560000/Star5")
)
Error: Incorrect number of parameters for function 'IMAGE()'. Expected 2, received 1
I written one formula for displaying images for different condition.
IF( Total_Lead_Score__c<20, IMAGE('/resource/1502342615000/Star1', 'Star1'),
IF( Total_Lead_Score__c<40, IMAGE('/resource/1502342589000/Star2', 'Star2'),
IF( Total_Lead_Score__c<60, IMAGE('/resource/1502342560000/Star3', 'Star3'),
IF( Total_Lead_Score__c<60, IMAGE('/resource/1502311560000/Star3', 'Star4'),
IMAGE('/resource/1502342499000/Star5','Star5')))))
This produces a Compiled formula too big error
CASE( Total_Lead_Score__c ,
Total_Lead_Score__c<20,IMAGE("/resource/1502342615000/Star1"),
Total_Lead_Score__c<40,IMAGE("/resource/1502342589000/Star2"),
Total_Lead_Score__c<40,IMAGE("/resource/1502377589000/Star3"),
Total_Lead_Score__c<40,IMAGE("/resource/15023222000/Star4"),
IMAGE("/resource/1502342560000/Star5")
)
Error: Incorrect number of parameters for function 'IMAGE()'. Expected 2, received 1
The error is due to the missing required 2nd parameter for the IMAGE function. Please try using the below formula and let me know if this works for you.
if(Total_Lead_Score__c<20,IMAGE("/resource/1502342615000/Star1","Green"),
if(Total_Lead_Score__c<40,IMAGE("/resource/1502342589000/Star2","Green"),
if(Total_Lead_Score__c<50,IMAGE("/resource/1502377589000/Star3","Green"),
if(Total_Lead_Score__c<60,IMAGE("/resource/15023222000/Star4","Green"),
IMAGE("/resource/1502342560000/Star5","Test")
)
)
)
)
I written same formula but it saying like:
Error: Compiled formula is too big to execute (8,726 characters). Maximum size is 5,000 characters
That why i am using CASE please help me with that.
I am not getting the compilation error when i am storing the same formulae in my org.
CASE( Total_Lead_Score__c ,
Total_Lead_Score__c<20,IMAGE("/resource/1502342615000/Star1"," "),
Total_Lead_Score__c<40,IMAGE("/resource/1502342589000/Star2"," "),
Total_Lead_Score__c<60,IMAGE("/resource/1502342560000/Star3"," "),
Total_Lead_Score__c<70,IMAGE("/resource/1502342536000/Star4"," "),
IMAGE("/resource/1502342499000/Star5", " ")
)