IF Then with > and < Condition Error

alyssa_sedai

The answer is probably staring me in the face.  However if I actually go to finish the If/Then statement

It freaks out when I try and add the final EndIf. I have tried to do it with and without the ().  There must be something wrong.  Nor do I care what the last Else is coded too as there really shouldn't be anything left.

Can anybody tell me what I am missing?

Thanks in advance!

clmc9601

Hi @alyssa_sedai,

What is the data type of your field [sum_sales_week_95]? The error message the formula tool is giving you looks like you are trying to do math on a string field. The solution to that issue is to change it to a numeric field!

Also, I believe you could accomplish this binning with the manual cutoffs configuration in the tile tool... just a thought!