Syntax for Select Function on Time Periods

Options
serena_zhang
serena_zhang Member, ALL USERS, Employee Posts: 5 Master Anaplanner of the Year
in Planning & Modeling

What are the time periods that I can use select function for?

Tagged:

Comments

  • serena_zhang
    serena_zhang Member, ALL USERS, Employee Posts: 5 Master Anaplanner of the Year
    Depends on the time settings you have for the model, you can do select formula on different time periods. 
    As you can see on the screenshot attached. My time setting is by week and I have Quarter Totals/ Half Year Totals/ Year To Date / Year To Go/ Total of All Periods checked. I can use select on the following time periods. 
    Select: Time. All Periods
    Select: Time. 'FY14’
    Select: Time. YTD
    Select: Time. YTG
    Select: Time. 'H1 FY14'
    Select: Time. 'Q1 FY14'
    Select: Time. 'Jan 14'
    Select: Time. 'Week 21 FY14’
  • rtorok
    rtorok Member, ALL USERS, Partner, Community Pioneer Posts: 2 Master Anaplanner of the Year
    I have a client with a multi-year model.  In the initial build, we used the Select Time function to select the specific fiscal year we wanted the formula to pick up.  However, as the client uses the model in future fiscal years, this means a relatively long manual exercice of changing these formulas to go from Select Time FY 14 or Select Time Dec14 to 2015 periods and then 2016 etc.

    We also have a control module which specifies things like current fiscal year and prior fiscal year; obviously these are easy changes to make and need only be done once per year.

    Querstion - can we write the Select Time function with a reference to another module?  EG: Select Time: Control Module.Prior Fiscal Year.  I didn't write the sytax correctly but trust you follow my question  Thanks

Categories