Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start 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