+ Start a Discussion
jgreene.ax1178jgreene.ax1178 

Making an Image Formula!

Hey all!

Trying to make a formula that will show as a 'green flag' if this field is having a value of 100 or greater.

IF (pi__score__c  > "100",IMAGE("/img/samples/flag-green.gif","green"),IMAGE("/img/samples/flag_red.gif","red"))

However I'm getting an error - any thoughts as to why?  I'm wondering if it's because of the custom field? 

Thanks!
nikkeynikkey
Hi Jgreene , 

is ur "pi__score__c " field a number data type.Then try this code :



IF 
(pi_score__c >=100, IMAGE("/img/samples/flag_green.gif","Greater Than 100 "),
IF
( pi_score__c<=99,IMAGE("/img/samples/flag_red.gif","Less than 99 "),

IMAGE("/img/samples/flag_yellow.gif","null")
)
)

 or

Refer to this link 
http://www.shellblack.com/administration/using-image-formula-fields/

 
jgreene.ax1178jgreene.ax1178
@nikkey - thanks so much!  That is exactly what I needed:)  Works like a charm now!

-Jake