COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: reportit on 12 May 2013 05:57:20 PM

Title: Exclude formula
Post by: reportit on 12 May 2013 05:57:20 PM
I have a report containing departments.  The report needs to exclude a few departments.   We have over 100 department so it would be easiest to filter using an exclude formula.  Does anyone know such formula?

Title: Re: Exclude formula
Post by: blom0344 on 13 May 2013 02:26:51 AM
example:   [department] not in ('dep1','dep2','dep3')