Invalid type operator <

[Ben_D_S]

How is the 2nd < causing this formula (which was copied from a class exercise so I know it should work) to not complete

IF [Avg Sales per Customer] < 100
THEN 'Low'

ELSEIF [Avg Sales per Customer]< 200
THEN 'Avg'

ELSE 'High'
ENDIF

[binuacs · Accepted solution]

@Ben_D_S make sure the data type of the field [Avg Sales per Customer] is numeric not string type

[Chaoued · Accepted solution]

Try This :

IF Tonumber([Avg Sales per Customer]) < 100
THEN 'Low'

ELSEIF Tonumber([Avg Sales per Customer]) < 200
THEN 'Avg'

ELSE 'High'
ENDIF

NB : The type of the new column is a string

[Ben_D_S]

Thank you!