Test Score / Less Than / Calculation

[AlanP]

I know this is somewhere in FileMaker help, but I can't find it.

I would like to have a calculation show 'Failed Test' if the number in a certain field is below the number '70'. How do I do this?

Thanks!

[Lee Smith]

Try for calculation:

Case ( Test_Score < 70 ; "Failed Test")

HTH

Lee

[AlanP]

Thanks! I figured it had to be something simple : :

[AlanP]

Sorry I have to followup with with this question.

This works great, until the test score is 100 (top score), then it shows failed. I'm guessing because of the 0's or 1.

Is there a fix for this? I'm assuming there must be somewhere this issue has cropped up before. Much much thanks!

[Raybaudi]

Be sure that "Test_Score" is a number field and NOT a text field

[Lee Smith]

I agree with Daniele,

It sounds like your field is a text field. A number will not act properly in a text field. In this case, the 100 is reading as 1, and therefore is a failing grade.

They will also sort wrong.

HTH

Lee

[AlanP]

That was it : thank you all