Prompts with OR

[jcb267]

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

[pradeepalankar]

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

[TomKari]

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

[Jagadishkatam]

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

[jcb267]

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