I'm working on an Autism screening form and would like to create three visibility text messages dependant on the score range. The score function works fine and the visibility works up to a score of 9. A score of 10 and more triggers the >=0 and <3 visibility. It's like it's seeing the score of 10 and more as a 1.
Here's my three codes:
Low-Risk Visibility #1 - (score of 0-2)Works Perfect
obsnow("M-CHAT SCORE") >= "0"
AND
obsnow("M-CHAT SCORE") < "3"
Medium-Risk Visibility #2 - (score of 3-7)Works Perfect
obsnow("M-CHAT SCORE") >= "3"
AND
obsnow("M-CHAT SCORE") < "8"
High-Risk Visibility #3 - (score of 8-20) Works up to 9; scores of 10-20 triggers Visibility#1
obsnow("M-CHAT SCORE") >= "8"
AND
obsnow("M-CHAT SCORE") < "21"
You want them all to evaluate based on value, not a string, like this
val(obsnow("M-CHAT SCORE")) >= 8
AND
val(obsnow("M-CHAT SCORE")) < 21
Thank you. This worked. Really appreciate your help.