Formula tool

Ainekeenan99

Hi 

Im trying to write the following into the formula tool - if [bmi] > 24.9 THEN "1" elseif [bmi] < 18.5 THEN "2" else "3" endif

it keeps coming up with the following error - Error: Formula (5): The formula "bmi" resulted in a string but the field is numeric. Use ToNumber(...) if this is correct. (Expression #4)

anyone able to help me?

atcodedog05

Hmm thats great

Can you check you data to see if there is any value below 18.5 so that it will be tagged as 2

You can use a filter tool for this.

If you are still facing the issue. You can try this once

if ToNumber([bmi]) > 24.9 THEN 1 
elseif ToNumber([bmi]) >= 18.5 THEN 3 
else 2 endif

If you are still facing issue share me a snapshot where you think value should have been 2.

Will be happy to help 🙂