Is there a way to create a module using the calendar year?

WaelGhrayeb
WaelGhrayeb
edited January 16 in Modeling

My fiscal year starts from September 25 for example, if I need a module to reflect the calendar year as a time scale instead of fiscal, how can I do it?

Answers

  • JFAnaplanner
    JFAnaplanner

    The only method to change this for a model is to change the "Fiscal Year Start Month" in the Time Settings to match the start of the year. The only problem with this is that it is a model wide change, so if you have other calculations that depend on the fiscal year this will not be possible. What is the problem that you are facing?

  • WaelGhrayeb
    WaelGhrayeb

    Thank you for the response, the thing is we usually have a report an excel that is in calendar years not fiscal, and I guess there is no other way than changing the fiscal year for the whole model, which is not an option as it will ruin the data in the whole model.
    I was thinking if I create a list with the fiscal year weeks for example and identify each week to its corresponding calendar week and use that as the time list for the specific module, but I think it is more complicated than that.

Categories