Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Struggling with IF THEN

mhauler
Alteryx
Alteryx

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'.  

 

Screenshot 2023-06-21 170929.png

 

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

4 REPLIES 4
alexnajm
17 - Castor
17 - Castor

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
20 - Arcturus
20 - Arcturus

Or ....

 

tonumber([deaths]) >= 100

 

 cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
mhauler
Alteryx
Alteryx

Thank you!  This helped tremendously.  

alexnajm
17 - Castor
17 - Castor

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

Labels