Print Page - MTD Last Year

Title: MTD Last Year
Post by: dollipi on 21 Feb 2020 04:43:15 AM

Hello,

I need MTD but from last year.

This is my formula for current year:

[DATE] between _first_of_month (current_date) and current_date

Regards,
D.

Title: Re: MTD Last Year
Post by: BigChris on 21 Feb 2020 05:19:08 AM

[DATE] between _first_of_month(_add_years(current_date,-1)) and _add_years(current_date,-1)

Title: Re: MTD Last Year
Post by: dollipi on 21 Feb 2020 05:39:58 AM

Great THX!

Title: Re: MTD Last Year
Post by: dollipi on 27 Feb 2020 10:03:20 AM

I have in my query MTD current year and now MTD last year

MTD last year:
[DATE] between _first_of_month(_add_years(current_date,-1)) and _add_years(current_date,-1)

Unfortunately our system calculates back one day. So when I query on February 27th, I get the following:

current year: 1 Feb - 26 Feb
last year: 1 Feb - 27 Feb

Therefore I need a solution for minus one day for MTD last year

Can someone help?

BR
D.

Title: Re: MTD Last Year
Post by: BigChris on 28 Feb 2020 02:04:54 AM

Just take a day off current_date using the _add_days function before you take a year off.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: dollipi on 21 Feb 2020 04:43:15 AM