Referencing Model Calendar in Formula

Gslater
Gslater
in 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:

Best Answers

  • rob_marshall
    rob_marshall
    Answer ✓

    @Gslater ,

     

    Is the Time Calendar you have above based on "real time" or fake time?  If real time, simply create a line item (for instance your Fiscal YR), formatted as Time Period - Year.  Enter the formula, item(time).

     

    2019-05-28_19-07-08.png

     

    2019-05-28_19-07-18.png

     

    Hope this helps,

     

    Rob

  • rob_marshall
    rob_marshall
    Answer ✓

    @Gslater ,

     

    Sure...Real Time is the true Time dimension vs. Fake Time is a list that "looks" like real time.  Based on your question, I am assuming you are using "Real" Time.

     

    Thanks,

     

    Rob

Answers

  • Gslater
    Gslater

    Hi Rob, 

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

    Also I'll give the solution a go.

  • PaulRitner
    PaulRitner

    Hi,

     

    Real Time is native Anaplan Time; fake time is a custom list that may look akin to Anaplan Time when used in a module, (such as a custom list of weeks, with parent list items representing months), but is not Anaplan Time.. .and doesn't respond to built-on time related functions and behaviors.

     

    In Rob's example, formatting the line item to Year (...Anaplan Time in Years) causes the formula "Item(Time)" to return the current year's value... in order for this to work, the Time Scale must be included (in some way) in the module/line item (apart from the Format of the line item itself)

     

    Cheers!

     

     

Categories