testing against a two digit number

[titanium]

Hi, I have the following calculation in one of my database fields. The test will check if a specific field has a value of 3 or above, and if so marks Passed, otherwise marks failed. It works fine as long as the result of the field isnt a two digit number that starts with 1 or 2. (11, 21, 19, 25 etc) . The calculation below seems to only be evaluating the first number, not  the total number. 

 

If (  ( Initial Test Buffer PSID ≥  "3"); "Passed" ; "Failed")

 

another with the same issue, but 2 rather than 3: 

 

If (  ( Initial Test Relief Valve Opened at psid ≥  "2"); "Passed" ; "Failed")

 

 

I would love to hear feedback to how I can fix that. Thanks so much! 

[doughemi]

Take the quote marks off the number.  They tell FileMaker to evaluate the number as a string rather than a number, which produces the result you are seeing.

 

( Initial Test Buffer PSID ≥  "3")  should be  (Initial Test Buffer PSID ≥  3)

[comment]

Also make sure that Initial Test Buffer PSID is a Number field.

[titanium]

Thanks so much! both those were precisely what I had wrong. Now its works perfect. Thank you for the VERY FAST responses. 

[LaRetta]

 

If (  ( Initial Test Buffer PSID ≥  "3"); "Passed" ; "Failed")

 

 

And just for future, you can drop that extra set of parentheses because they aren't needed, so it becomes:

 

If (  Initial Test Buffer PSID ≥  3 ; "Passed" ; "Failed" )

 

:-)