Filemaker Pro 8.5 Advanced Maintenance TG761Z/A User Manual

Case(test1;result1{;test2;result2;defaultResult...})

test - any text or numeric 

.

result - result corresponding to the expression.
Parameters in curly braces { } are optional.

text, number, date, time, timestamp, container

Returns one of several possible results based on a series of tests.
The Case function evaluates each test expression in order, and when a True expression 

is found, returns the value specified in result for that expression.
You can include a default result at the end of the parameter list. If none of the expressions 
evaluate to True, the Case function returns the value specified for defaultResult. If no 

default result is supplied, the Case function returns an “empty” result.

Case(Score >= 90;“Excellent”;Score > 50;“Satisfactory”;“Needs 
Improvement”) displays 

 when the score is 90 or above, 

 when 

the score is between 50 and 90, and 

 for any other score.

Case(Shipment Method=”Ground”;2;Shipment Method=”Air”;10) returns 

, 

when the Shipment Method field contains Air.

Choose(test;result0{;result1;result2...})

test - Any integer calculation. The calculation result of test must be a number that 

 into the list that follows. Because the index is a 0 based index, the test result must 

be 0 to access the first result.

result - one or more results. 
Parameters in curly braces { } are optional.