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

Show reports count for the last 3 months.

Started by Web2CRM, 04 Jul 2013 11:47:09 PM

Previous topic - Next topic

Web2CRM

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!!!

MFGF

Hi,

How about:

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

Cheers!

MF.
Meep!