Conditional function question

[stphnwl]

Hi All,

First post here.

I'm trying to write a simple conditional statement that will convert anything greater than 12 into simply 12. Here's what I have, but I'm receiving an "Invalid type in operator >." error. Could anyone please advise?

IF [total_months] > 12 THEN 12 ELSE [total_months] ENDIF

Thanks!

[NicoleJohnson · Accepted solution]

It's likely that your field type for [total_months] is something other than a numerical type.

Try this: IF ToNumber([total_months]) > 12 THEN "12" ELSE [total_months] ENDIF

Alternatively, if you put a select tool in front of your formula tool and change the field type for [total_months] to a numeric format, then you can leave your formula as is!

NJ

[stphnwl]

Thanks, NJ.

I was actually about to post that my data was still in V_WString! You're quick!

Thanks a bunch for the additional formula education.