FileMaker Pro 8.5 container case statement using 3 reps
Posted on 2009-07-02
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 ; cont1)
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  is colored white. I want it to be white  if empty. The above calc for  and  stay as they are.