Print Page - Show reports count for the last 3 months.

Title: Show reports count for the last 3 months.
Post by: Web2CRM on 04 Jul 2013 11:47:09 PM

Hi,

Can someone help me with dates manipulation used as filter in report studio?

I need to create a computed Data Item "Count" with expression that will only show sum of the count for all reports with that report id run in the last 3 months (so [Bu Date] > System Date - 3 months).

Thanks!!!

Title: Re: Show reports count for the last 3 months.
Post by: MFGF on 05 Jul 2013 05:12:14 AM

Hi,

How about:

[BU Date] > _add_months (current_date, - 3)

Cheers!

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Web2CRM on 04 Jul 2013 11:47:09 PM