Struggling with IF THEN

[mhauler]

I'm struggling with an IF THEN and hoping you all might be able to help.  I have an output that will produce a number between 0 and 500.  The overall goal is to have the statement produce an output that calculates a relative risk level based on the output.  For example, if you received a score of 25 out of 500 (0 to 100 being 'Low Risk'), an additional column would be created showing 'Low Risk'.  

I know this should be an easy solution but I've just been banging my head against the wall.  

[alexnajm · Accepted solution]

I would remove the string quotes from 100! As long as [Avg Deaths per 100,000] is stored numerically, this should work: IF [Avg Deaths per 100,000] > 100 THEN 'Low Risk' ELSE 'NA' ENDIF

[MarqueeCrew]

Or ....

tonumber([deaths]) >= 100

 cheers,

 mark

[mhauler]

Thank you!  This helped tremendously.  

[alexnajm · Accepted solution]

Fantastic! Make sure to accept the solution(s) that helped so others can use these forums in the future as a reference 😊