Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

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
21 - Polaris
21 - Polaris

@pvara 

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

0224-pvara.PNG

Labels
Top Solution Authors