Skip to main content
Topics#Data ManagementFrage von Christine Saxon
Christine Saxon fragte in #Data Management
2. Aug. 2012, 16:01

Formula - Image field using a number range?

I'd like to create a formula using the star images as a rating, but I'm unsure how I can accomplish this with a number range  - can someone assist?

 

IMAGE(

 

CASE(Text( Weekly_Performance_Rating_Calc__c ,

 

"0-1.99", "/img/samples/stars_100.gif",

 

"2.00-2.50", "/img/samples/stars_200.gif",

 

"2.51-3.00", "/img/samples/stars_300.gif",

 

"3.01-3.51", "/img/samples/stars_400.gif",

 

"3.52-9999", "/img/samples/stars_500.gif",

 

"/img/samples/stars_000.gif"),

 

"rating"))
10 Antworten
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2. Aug. 2012, 16:35
    May bad (that's what I get for

     

    AND(Coding,

     

    ISNULL(Coffee)) 

     

    Here you go:

     

    IF(  Weekly_Performance_Rating_Calc__c  >= 3.52, IMAGE("/img/samples/stars_500.gif", "rating"),

    IF( Weekly_Performance_Rating_Calc__c   >= 3.01, IMAGE("/img/samples/stars_400.gif","rating"),

    IF( Weekly_Performance_Rating_Calc__c   >= 2.51, IMAGE("/img/samples/stars_300.gif","rating"),

    IF( Weekly_Performance_Rating_Calc__c   >= 2.00, IMAGE("/img/samples/stars_200.gif","rating"),

    IF( Weekly_Performance_Rating_Calc__c   >= 0, IMAGE("/img/samples/stars_100.gif","rating"),

    IMAGE("/img/samples/stars_000.gif","rating"))))))

Antwort schreiben...
0/9000