Quarterly Calc for Each Fiscal Year

[HelloCognos]

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

[Cognos_Jan2017]

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.