bobrossi56
asked on
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...
BobR
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...
BobR
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER