Help with a formula
This formula produces always the Default Text (NOT SPECIFIED)...
The field 'Score' is a Number field.
switch number(Score) do
case > 90:
text("EXCELLENT")
case >= 75 and <= 85:
text("SATISFACTORY")
case >= 60 and <= 70:
text("NEEDS IMPROVEMENT")
case >= 45 and <= 55:
text("UNSATISFACTORY")
default:
text("NOT SPECIFIED")
Also, I had no luck with
switch Score do...
What am I doing wrong?
2 replies
-
Nick, try this...
switch Score > 0 and Score <= 100 docase Score >= 90 and Score <= 100:"EXCELLENT"case Score >= 75 and Score < 90:"SATISFACTORY"case Score >= 60 and Score < 85:"NEEDS IMPROVEMENT"case Score >= 45 and Score < 60:"UNSATISFACTORY"default:"NOT SPECIFIED"endIt looks like you have to specify the complete range you are testing for in the "switch" part and then test each segment in the "case" part. You left a 5 point gap between case statements so I adjusted for that. Also, you have to include the "Score" field in your case statements.
Sean
-
Thanks a lot Sean
Works fine!
Content aside
- 6 yrs agoLast active
- 2Replies
- 1227Views
