Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Less than or Equal to Expression help

pvara
8 - Asteroid

I need a little help with my expression to obtain the correct results.

The business case is as follows: If %DataQuality is +/- 20 then Green. Assuming DataQuality is 0, then -80 thru 20 should result in Green, else Red.

 

Here is my current Expression

If [%DataQuality] <=20 AND [%DataQuality] >= -80 THEN "Green" else "Red" ENDIF

 

 

pvara_0-1614120299186.png

 

Thank you in advanced

 

PhilipMannering
14 - Magnetar
14 - Magnetar

Not sure I follow @pvara. Could you show your desired output?

pvara
8 - Asteroid

 

The Desired output would look like this...

 

pvara_0-1614121339809.png

 

 

 

Qiu
16 - Nebula

@pvara 

Maybe I am missing something, but it seems to be an easy one.

0224-pvara.PNG

Labels