Solved

FileMaker Pro 8.5 - Case statement question...

Posted on 2009-07-01
2
286 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 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