FileMaker Pro 8.5 container case statement using 3 reps

I have a situation where I am using a Case statement to turn a container either red or green colored based on the results of a "total" field. The statement I was using is:
CASE ( total < 0 or total > 1 ; cont1[2] ; cont1[1])

This is working fine, but suppose I want to NOT color the field if its empty. I assume I would need to add a third repetition to the container, but how would I structure the CASE statement? Lets assume the container rep [3] is colored white. I want it to be white [3] if empty. The above calc for [1] and [2] stay as they are.

thx experts...
Who is Participating?
North2AlaskaConnect With a Mentor Commented:
You could but maybe just don't set it to anything at all.

CASE ( isEmpty (total) ; "" ;
           total < 0 or total > 1 ; cont1[2] ;

I don't know if that will work.  Otherwise, do as you suggested and create another repetition of the container and change the "" to cont1[3].
bobrossi56Author Commented:
Works like a charm, thx
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.