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

Filtering Data in a List Report in Report Studio

Started by Cognuser, 29 Oct 2010 10:03:58 PM

Previous topic - Next topic

Cognuser

I have a list report with two filters

[PERIOD] in ('3Q', '4Q')
[PLAN_VALUE] in (['Current_Plan', 'Prior_YR_Plan')

I want two columns in the list to one reporting Plan numbers for the current year and plan numbers for the prior year.

I have two data items created

IF [PERIOD] = '3Q'
THEN [PLAN_VALUE]
ELSE (0)

and the second is

IF [PERIOD] = '4Q'
THEN [PLAN_VALUE]
ELSE (0)

For some reason I can get one number but not the other.  Does anyone have any ideas.....please!!!

I am using a DB2 data source.