### Title

Greater than/Less than calculating wrong

### Post

I'm ending up with a weird problem.

I have two numbers in a return-delineated list. For some reason, FMP is calculating "greater than/less than" wrong. For instance, if my values are 10 and 7, it'll tell me that my first value minus my second is 3, but that the first value is NOT greater than the second. see the attached screenshot.

Any ideas what I'm doing wrong?

10 > 7 is false when those values are text type.

So, the calc will be fair when you use something to transform the text to a number.

The second expression, using a minus operator, tells to FileMaker to get a number result, but this isn't the case of your third expression.

So, you could use:

GetAsNumber ( GetValue( $$Var ; 1 ) ) > GetAsNumber ( GetValue( $$Var ; 2 ) )