Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cbyrne123 on 01 Sep 2013 03:25:38 PM

Title: URGENT help needed please/show sales figures per month in list report
Post by: cbyrne123 on 01 Sep 2013 03:25:38 PM
Hello i am creating a list view report and need to show sales each month, so customer/Period 1, Period 2 etc, periods being Jan and Feb for example.

I have tried the below DataItem expression however this doesn't to work Properly.


IF  ([Period] ='7') THEN ([Line Value]) ELSE([Line Value])

Thanks

Chris
Title: Re: URGENT help needed please/show sales figures per month in list report
Post by: cognostechie on 01 Sep 2013 06:02:36 PM
You have the same value in THEN as well as ELSE.

Try - IF  ([Period] ='7') THEN ([Line Value]) ELSE(0)
Text only | Text with Images