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

RESOLVED: Filtering this month and last months' results

Started by ccbarbeau, 26 May 2011 01:44:57 PM

Previous topic - Next topic

ccbarbeau

Hi all,

I'm working on a project that requires that I show only records where this months' and last months' data meet a certain requirement.

My data is Sales by Month, so Sales January, Sales Febraury, etc.

I have written the calculations to extract the month from the current date and last month. I'm stumped, though, when it comes to the formula that states 'if this months' sales and last months' sales meets criteria, show record'

Can you please help?

Thanks!

CC

Resolved: I used an If statement; if [this month]='1' then [january data], etc. for each month and then filtered my report for the months I need.