Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering on financial previous YTD

Status
Not open for further replies.
Sidney786

Sidney786

Programmer
Aug 7, 2000
64
GB
Hi

I have created a report which shows last years sales and this years sales controlled by a date_to prompt.

However when I run up to previous month it keeps displaying including this month.

[FYS]>= IF (extract (month,?To_date?) in (01,02,03) )
THEN ((extract(year,?To_date?)-1)-1)
ELSE (extract(year,?To_date?)-1 )

Any pointers would be appreciated.

Sid
 
Status
Not open for further replies.

Similar threads

dredden2
  • Locked
  • Question
COGNOS Script to modify date ranges on a Dimension
Replies
0
Views
154
dredden2
dredden2
25456378
  • Locked
  • Question
Calculate date of previous day
Replies
0
Views
77
25456378
25456378
sruthi2016
  • Locked
  • Question
Help on cognos javascript to pass parameter from one report to another dynamically
Replies
0
Views
76
sruthi2016
sruthi2016
Gucha
  • Locked
  • Question
Cognos aggregation (summary on multiple measures on different hierarchy levels)
Replies
0
Views
106
Gucha
Gucha
JMDONS
  • Locked
  • Question
Rolling 12 months total for each month of current FY and previous FY
Replies
0
Views
56
JMDONS
JMDONS

Part and Inventory Search

Sponsor

Back
Top