We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start 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
14 - Magnetar

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