Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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

 

3 REPLIES 3
PhilipMannering
16 - Nebula
16 - Nebula

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

@pvara 

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

0224-pvara.PNG

Labels