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
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