Hello,
I'm trying to create a value prompt that will allow a user to make a selection from a multi value text item separated by semi colons.
So the multi select value prompt looks like this:
Blue
Green
Red
Yellow
And the data item it will filter is based on this:
Blue; Green; Red; Yellow
The parameter I'm using is [All Colors] in ?Select Color? but it is selecting all the colors in the data item, not the one(s) I select. How do I get it to just return Blue for example?
Currently, if I select Blue, it returns everything. For example, it will return rows where Red is the only value in the text item.
I just discovered when I use [All Colors] contains ?Select Color?, it works but the prompt no longer allows multiselect--only one value. Is there a work around?
Thank you.