Alteryx Designer Desktop Discussions

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

Formula Help

greenman73
7 - Meteor

Hi Alteryx Team,

 

I have a formula question.  I have been using a formula to located certain conditions but i think i need more coding to get to what i am looking for.

 

This is what i am trying to do:

 

If Access A or Access B or Access C are showing then Access D also need to be showing. 

 

So i want the output to show any row where Access D is missing but Access A or Access B or Access C are present.

 

I hope i explained that well enough.

 

Thank you

Jonathan

1 REPLY 1
Matthew
11 - Bolide

an example input would be helpful, but if i understand correctly, you want something like this

Matthew_0-1663948557046.png

 

or if you want it as a separate formula to flag when the condition is true, then you could do this

 

Matthew_0-1663948852235.png

 

 

Labels