Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: peewan on 17 Feb 2021 04:52:57 PM

Title: Filter on range of value: start with C00-C99
Post by: peewan on 17 Feb 2021 04:52:57 PM
I want to filter on any Code that start with C00-C99 and M00-M99
example: C00001, C25003, C89000, C99045...

How could I do this?

Thank you
Title: Re: Filter on range of value: start with C00-C99
Post by: BigChris on 17 Feb 2021 04:57:07 PM
Code Select
substring([CodeField],1,3) between 'C00' and 'C99' or substring([CodeField],1,3) between 'M00' and 'M99'
Text only | Text with Images