Solved

FileMaker Pro 8.5 - Case statement question...

Posted on 2009-07-01
2
280 Views
Last Modified: 2012-05-07
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 < 1 ; cont1[1] ; cont1[2] )

This works great. However, my end user just informed me that he needs to change this equation such that any result in the "total" field that is BETWEEN and including 0.00 and 1.00 should turn the cont1[1] (green) and anything above OR below that range should turn cont1[2] (red).

I am not sure how this statement should be phrased.
thx experts...
-BobR
0
Comment
Question by:bobrossi56
2 Comments
 
LVL 12

Accepted Solution

by:
North2Alaska earned 500 total points
ID: 24758792

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

       cont1[1]

)

Open in new window

0
 

Author Closing Comment

by:bobrossi56
ID: 31598954
Works like a charm. Didn't know you could put an OR expression in a Case statement. Thx...
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now