AnsweredAssumed Answered

Case Function Problem

Question asked by brianj77 on Jul 30, 2013
Latest reply on Jul 31, 2013 by brianj77

Case Function

 

I am using a Case function to display a wee risk management equation as follows:

 

Score = x

Risk Status = Output

 

I am tying to simply to display following results:

 

Score =<3 Status Display = Standard

Score between 3 and 5 Status Display = Medium

Score between 5 and 7 Status Display = Medium

Score >=7 Status Display = Very High

 

 

When I use this equation the result display as they should (which is similar to the example given in the Filemaker Help>Functions menu

 

Case ( Risk_Score ≤ 3 ; "Standard" ; Risk_Score ≥ 8 ; "Very High" ; "Normal")

 

 

However I have a few interim results to display which don't display properly

 

Case (

Risk_Score ≤ 3 ; "Standard" ;

Risk_Score ≥ 3 ≤ 5 ; "Medium" ;

Risk_Score ≥ 5 ≤ 7 ; "High" ;

Risk_Score ≥ 8 ; "Very High"

)

 

I guess my syntax is wrong as I cant the 'interim results to display (i.e. the 2 cases between 3-5 and 5-7

It has to be really simple but yet I can't get it to work as I need.

Anyone got any ideas what I need to do to get this working?

 

Thanks for your help in advance

Brian

Outcomes