If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Applying a filter based on a separate condition

Started by jwm68, 26 Jul 2006 11:39:56 AM

Previous topic - Next topic

jwm68

Hopefully someone can help with this one.

I have a filter in the tabular model of my query.  The filter is designed to weed out certain chunks/rows of data.

I want to only apply the filter if certain other conditions are met...specifically, I have a data item (name = isAdmin) in my report's tabular model that will either be set to 'TRUE' or 'FALSE'...it is a calculation based on the data returned by the CSVIdentity 

So, how do I only apply the filter when that data item is set to 'FALSE'?

As I was playing around with this, I tried this for my filter expression:

IF (isAdmin = 'FALSE') THEN ([Enrollment].[Benefit Employer Group].[Group Number]not in ('4750000','4750002','4759902','5320000','5320002','5329902','50010022','50019922','300100','50010092','50019992','50019993','50019994'))

That only gives me errors in the report.

Any assistance would be greatly appreciated.

Thanks.

Joe