YTD,MTD

jahnavi · 26 May 2011 01:10:18 PM

Hi,

How to calculate YTD,MTD in cognos. Pls help me

cognostechie · 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'

BSP Software	Resources	About Us
MetaManager	BSP Software Training	BSP Software
Integrated Control Suite	YouTube Channel	Micro Strategies Inc
Security Migration		IBM Cognos
Integrated Management Suite

If you are unable to create a new account, please email support@bspsoftware.com