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.