Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jahnavi on 26 May 2011 01:10:18 PM

Title: YTD,MTD
Post by: jahnavi on 26 May 2011 01:10:18 PM
Hi,

How to calculate YTD,MTD in cognos. Pls help me
Title: Re: YTD,MTD
Post by: cognostechie on 26 May 2011 04:48:43 PM
YTD - extract(year,[Date]) = extract(year,current_date) and [Date] <= current_date

For MTD, use same condition but replace the 'Year' with 'Month'
Text only | Text with Images