Compare errors - related to variable type?

[rgnant]

I am having a problem where $$Variable is evaluating as less than Table:Field where it shouldn't.  For example Table:Field is 65 and $$Variable is 100.  Anything up to $$Variable=99.9999999 will evaluate as greater than 65, but any 3 digit entry (100 or above) evaluates as less than 65.

Table:Field is a number, the only way I could see this happening is if $$Variable is typed as text, but I cannot control it. $$Variable is entered in a Custom Dialog Box.

[Ocean West]

Try GetAsNumber ( $$variable) before you perform any math operation on the amount, FileMaker defaults variables as TEXT it does it's best to cast the value based on if it was coming from a known data type.

Quote

The data type of a variable is determined dynamically based on the assigned data. Variables have the same data types as fields, except for calculation and summary fields.

 

You also may need a custom function to format a variable string to display properly in a text string of a custom dialog box.

[rgnant]

Thanks, GetAsNumber worked.  I just figured it would input a number as a number.