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
an example input would be helpful, but if i understand correctly, you want something like this
or if you want it as a separate formula to flag when the condition is true, then you could do this
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |