Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Return a RAG based on conditions that have symbols in them

lachie_hillis
5 - Atom

Hi, would anyone be able to help me out here. I am trying to automate some KPIs and I want to return a RAG based on the value column. Depending on whether the value falls into Gold, Green, Amber, or Red - I want to return that in the RAG column. The only problem is that I have other symbols in those columns. Attached is a screenshot .Capture.PNG

1 REPLY 1
DavidSkaife
13 - Pulsar

Hi @lachie_hillis 

 

Do you need to specifically reference those columns, or could you not just build the logic into some formula tools like below:

 

DavidSkaife_0-1660303898390.png

 

Labels
Top Solution Authors