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.

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
Top Solution Authors