Print Page - Quarterly Calc for Each Fiscal Year

Title: Quarterly Calc for Each Fiscal Year
Post by: HelloCognos on 20 Sep 2018 01:26:03 PM

Hi, :)
I'm using the below function for Quarterly evaluation of each year but I need to do it based on fiscal year (oct 1 2017- Sept 30 2018)

floor((month-1)/3) +1
Does this need to change?

Thanks for your time

Title: Re: Quarterly Calc for Each Fiscal Year
Post by: Cognos_Jan2017 on 20 Sep 2018 02:44:05 PM

We have the same Fiscal Year definition.

Our DB also has a Field to describe the Month Order of a Fiscal Year, IE ...
October = Month 1 of the FY
November = Month 2 of the FY
......................
September = Month 12 of the FY

IF your DB has similar Field design, you can
calculate Quarterly Totals based on the above.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: HelloCognos on 20 Sep 2018 01:26:03 PM