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
Thank you in advanced
Solved! Go to Solution.
Not sure I follow @pvara. Could you show your desired output?
The Desired output would look like this...