Print Page - Return MPY and MCY

Title: Return MPY and MCY
Post by: t0mato on 23 Mar 2021 04:28:22 PM

Hi,

What would the query function be to return Month Prior Year (current month in the previous year, example output "March 2020"), Month Current Year (current month in the current year, example output "March 2021")?

I'm hoping to use these calculations for a monthly, active report and utilize these for the Headers of the report.

Thank you!

Title: Re: Return MPY and MCY
Post by: t0mato on 23 Mar 2021 04:33:13 PM

NEVERMIND! PLEASE CLOSE.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: t0mato on 23 Mar 2021 04:28:22 PM