Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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