IF Formula - Invalid Type In Operator

[javerna]

Hi! Can anyone help me understand why I'm getting the following error with my formula below: "Invalid type in operator <"

IF [AYR] < [PriorPrior]
THEN -9999
ELSE [AYR]
ENDIF

[alexnajm · Accepted solution]

You may be comparing a number or a string or vice versa - check your data types!

[flying008]

Hi, @javerna 

FYI.

IIF(ToNumber([AYR]) < ToNumber([PriorPrior]), -9999, [AYR])