COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: Cognosnewbie26 on 02 Sep 2020 12:24:50 am

Title: Calculations for relative time
Post by: Cognosnewbie26 on 02 Sep 2020 12:24:50 am
Hi,
My time dimension looks like below:
Year
Quarter
Month
Date
I want to create a calculation for Prior Time ( it can be prior year, quarter, month or same date of previous year)
I was wondering if I can create a calculation in such a way that it is able to gauge  if it is a year, quarter, month or date is pulled for the current year
For e.g
                           Month     PYMonth
Account No

In the above case if I pull the 'Month' then it should be able to calculate the amount for the PYMonth