I have the following formula:

Case (

MilesuntilService ≤ 3000 ; "Good";

MilesuntilService ≤ 4500 ; "Service Soon" ;

"Schedule for Service"

)

I want the text to change color depending on what is in the Service Status field, for example - "Good", text will be green - "Service Soon", Text is yellow, and - "Schedule for Service", text is red.

I have placed the TextColor calc in several different spots - sometimes I get too many parameters error, or the field lists a 1 or 0 even through the calc should return Text. I not am getting where the placement of the additional info should be. I swear I took several, hours long stabs at trying to figure this out myself including search this forum and FM Help.

Here two examples of things I tried:

Case (

MilesuntilService ≤ 3000 ; "Good" ; TextColor ( "Good" ; RGB ( 0 ; 255 ; 0 ));

MilesuntilService ≤ 4500 ; "Service Soon" ; TextColor ( "Service Soon" ; RGB ( 255 ; 255 ; 0 )) ;

"Schedule for Service" ;TextColor ( "Schedule for Service" ; RGB ( 255 ; 0 ; 0 ))

)

Case (

MilesuntilService ≤ 3000 ; "Good" ; TextColor ( NextService ; RGB ( 0 ; 255 ; 0 ));

MilesuntilService ≤ 4500 ; "Service Soon" ; TextColor ( NextService ; RGB ( 255 ; 255 ; 0 )) ;

"Schedule for Service" ;TextColor ( NextService ; RGB ( 255 ; 0 ; 0 ))

)

The above don't produce errors, but they also produce no results either.

Any thoughts/Advice?

Also, can anyone recommend a book like FM Calculations for Dummies? I am getting deeper into more complex calcs and I am really over my head at times.

Jessica

Edited January 16, 200719 yr by Guest

Hi

there's no 2 w/o a 3 ! :

So go to try this last calc:

Case (

MilesuntilService ≤ 3000 ; TextColor ( "Good" ; RGB ( 0 ; 255 ; 0 ));

MilesuntilService ≤ 4500 ; TextColor ( "Service Soon" ; RGB ( 255 ; 255 ; 0 )) ;

TextColor ( "Schedule for Service" ; RGB ( 255 ; 0 ; 0 ))

)

Thank you it works - I see where my calc was wrong, I put in too much info - wow you all here are just awesome! Thanks again!