Referencing Model Calendar in Formula

Options
Gslater
Gslater Member, ALL USERS Posts: 2 New Contributor
in Planning & Modeling

Hi all, 

I am trying to see if there is a way to reference the model calendar in a formula.

I want to return the fiscal year that the week is in.

e.g Week 1 FY19

Result would be FY19

The intention is to use this to lookup other data, 

E.g IF  Fiscal year = FYxx then...

I have a Timing - Calendar Module (screenshot below) if that helps...

Any help appreciated.

Calendar.jpg

 

 

 

Tagged:

Comments

  • Gslater
    Gslater Member, ALL USERS Posts: 2 New Contributor

    Hi Rob, 

    Can you explain what you mean by Real time / Fake time?

    Also I'll give the solution a go.

Categories