Hello Everyone,
Cognos Analytics v11 (relational data) Question.
I'm trying to create a prompt where the user can enter zip codes they would like to EXCLUDE from the results. Since they will be entering multiple five digit zips, I would like to use a wild card that says to exclude that five digit zip or any nine digit zip beginning with that five digit zip the user provides.
For example if the user enters 90210, I would like it to exclude the results 90210, 90210-0222, etc.
I've tried different versions of these but none seem to work:
[ZIP_CODE] not in '?Excluded_Zip?+%'
[ZIP_CODE] not in Starts With ?Excluded_Zip?
Thank you!
Cognos Analytics v11 (relational data) Question.
I'm trying to create a prompt where the user can enter zip codes they would like to EXCLUDE from the results. Since they will be entering multiple five digit zips, I would like to use a wild card that says to exclude that five digit zip or any nine digit zip beginning with that five digit zip the user provides.
For example if the user enters 90210, I would like it to exclude the results 90210, 90210-0222, etc.
I've tried different versions of these but none seem to work:
[ZIP_CODE] not in '?Excluded_Zip?+%'
[ZIP_CODE] not in Starts With ?Excluded_Zip?
Thank you!