Parse Error

Question

Hi! I'm trying to create a formula for Z-score classification.

When I enter in:

If [Z-score]<=1.8 Then "Unhealthy" Elseif [Z-score]>=3 Then "Healthy" Else "Unclassified" Endif

I get a parse error at char (52): invalid type in operator >=. (Expression 1)

Does anyone know how to fix this?

Thanks!

flying008 · Answer

Hi, @kluther2

In new field, the formula is :

IF ToNumber([Z-score]) <=1.8 THEN 'Unhealthy' 
ELSEIF ToNumber([Z-score]) >=3 THEN 'Healthy' 
ELSE 'Unclassified' ENDIF

alexnajm · Answer

Looks like z score is being stored as a string - change it to a numeric data type before this formula!