Good Morning,

I am trying to create a formula field "Total Health Score" where If the score is 1 - 4.75 = Good, 5 - 6.75 = okay and 7-10 = At Risk with colored Flags Red, Green and Yellow. I created the picklist field called "Total Customer Health Score" with At Risk, Good, and Okay. I am having trouble with if it is zero, then a green flag show. How would I either show a different flag or something else or not show anything if it is zero. Here is my formula I have now:

IF(
Total_Customer_Health_Score__c  <= 4.75 ,
IMAGE('/img/samples/flag_green.gif','Green Flag'),
IF(
Total_Customer_Health_Score__c  <= 6.75,
IMAGE('/img/samples/flag_yellow.gif','Yellow Flag'),
IF(
Total_Customer_Health_Score__c   >= 7,
IMAGE('/img/samples/flag_red.gif', 'Red Flag'),
IF(
Total_Customer_Health_Score__c = 0,
NULL, NULL))))

Good Morning,

I am trying to create a formula field "Total Health Score" where If the score is 1 - 4.75 = Good, 5 - 6.75 = okay and 7-10 = At Risk with colored Flags Red, Green and Yellow. I created the picklist field called "Total Customer Health Score" with At Risk, Good, and Okay. I am having trouble with if it is zero, then a green flag show. How would I either show a different flag or something else or not show anything if it is zero. Here is my formula I have now:

IF(
Total_Customer_Health_Score__c  <= 4.75 ,
IMAGE('/img/samples/flag_green.gif','Green Flag'),
IF(
Total_Customer_Health_Score__c  <= 6.75,
IMAGE('/img/samples/flag_yellow.gif','Yellow Flag'),
IF(
Total_Customer_Health_Score__c   >= 7,
IMAGE('/img/samples/flag_red.gif', 'Red Flag'),
IF(
Total_Customer_Health_Score__c = 0,
NULL, NULL))))