Desktop productivity for business analysts and programmers

Prompts with OR

Reply
Contributor
Posts: 22

Prompts with OR

Hi -

I have a prompt in my data that is looking at a column that is populated with a Y or an N.  If I want Y or N it seems to work fine but if I want both it does not work.  I suspect that the prompt creates a where clause that has an AND in it but this should be an OR......Is there any way to change this?

John

Frequent Contributor
Posts: 106

Re: Prompts with OR

your question is not clear...input/output data and some more explanation might help us understand better.

PROC Star
Posts: 1,146

Re: Prompts with OR

As mentioned above, the question is a bit vague, but here's a stab at it.

Try setting up your filter for an "In a list" condition, and it might work.

Tom

Trusted Advisor
Posts: 1,137

Re: Prompts with OR

Hope you have selected "Multiple Values" under number of values like below while creating the prompt and have used "in a list" condition as suggested by Tom.

Thanks,

Jag

Thanks,
Jag
Contributor
Posts: 22

Re: Prompts with OR

Thank you, Jag......this worked!

Ask a Question
Discussion stats
  • 4 replies
  • 306 views
  • 6 likes
  • 4 in conversation