Print Page - Create Prompt for Year and Period between Two Values

Title: Create Prompt for Year and Period between Two Values
Post by: epurwanto on 17 Sep 2020 07:57:19 PM

Hi Cognos gurus,

I really need help. I'm creating a financial report with prompt page that requires users to input from/to year & period.

[Year] = 2020, 2019
[Period] = 01, 02, 03, 04
[Expense] = various amounts

How can I create a prompt for users to get the total expenses between two year & period? So if user would like to see how much was spent from quarter 2 to quarter 2 of the following year, they will input 2019-02 and 2020-02.

Thanks!

Title: Re: Create Prompt for Year and Period between Two Values
Post by: BigChris on 18 Sep 2020 01:48:27 AM

Ok, the way I'd probably go about that is to create a calculation for year/quarter:
[Year] || '/' || case
when [Period] in ('01', '02', '03') then 1
when [Period] in ('04', '05' etc.
else null
end

Then your filter would just be [Year/Quarter] between ?Begin Year/Quarter? and ?End Year/Quarter?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: epurwanto on 17 Sep 2020 07:57:19 PM