Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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