• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Workday Adaptive Planning Use Cases
    • IBM Planning Analytics Use Cases
    • BlackLine Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Workday Adaptive Planning Tips & Tricks

Workday Adaptive Planning Tips & Tricks: Choose the Correct TIME Syntax

 

June 22, 2022

By Michelle Song

Are you familiar with all the TIME syntax in Workday Adaptive Planning? Do you know what is the best practice for each of them? This blog post will tell you the difference between them. 

Below are the most common TIME syntax in Adaptive Planning. 

  • Month(this) 
  • Versionmonth(this) – returns the 
  • This.year.positionof(this.month)
  • This.version.positionof(this.month)

In the following example, this instance has a custom calendar which is from July – June. The example is created using Month as the stratum. The same logics are applied to Quarter and Year. 

Graphical user interface, application, table

Description automatically generated

  • In July 2021, Month(this) returns the month in the standard calendar, which is month 7. This syntax also assumes that July is from July 1st to July 31st. For example, if 7/30/2021 in a custom calendar is actually a date in Aug 2021, then versionmonth(July-2021) and versionmonth(Aug-2021) will return the same number. This same situation also applies to Versionmonth(this).
Graphical user interface, application, table

Description automatically generated
  • Versionmonth(this) returns the month of the version, which also follows the standard calendar and assumes July is from July 1st to July 31st. 
Graphical user interface, table

Description automatically generated
  • This.year.positionof(this.month) returns the fiscal month of the year, which is month 1 for July-2021. This syntax references the custom calendar. For example, if 7/30/2021 in a custom calendar is actually a date in Aug 2021, then This.year.positionof(this.month) returns month 2 in the year, which is Aug 2021. Same situation applies to This.version.positionof(this.month). 
Graphical user interface, text, application

Description automatically generated
  • This.version.positionof(this.month) returns the month in the version since the Start of Version. In this case, the Start of Version is July 2021, therefore it is month 1 in the version. 

Other use cases and helpful formulas related to time. 

Personnel Sheet:

  • For Headcount calculation that has a Custom Calendar and Start Date before the system date
    • this.Year.positionof(this.Month)  – correct result, but shown as RED (error) on Income Statement because the date is outside of the system date. 
    • versionmonth(this) – might result in incorrect result due to date overlaps in two months. 
    • Use iff(ROW.PartialHeadcount>0, 1,0) as a workaround. 
  • Cumulative Salary
    • Standard calendar: 

iff(month(this)>1, ROW.Salary+ROW.CumulativeSalary[time=this-1], ROW.Salary)

  • Customized calendar:

iff(this.Year.positionof(this.Month)>1,ROW.Salary+ROW.CumulativeSalary[time=this-1], ROW.Salary)

Visit Revelwood’s Knowledge Center for our Workday Adaptive Planning Tips & Tricks or sign up here to get our Workday Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start with Workday Adaptive Planning? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Flexible Planning

Workday Adaptive Planning Tips & Tricks: Common Questions Asked During Training

Workday Adaptive Planning Tips & Tricks: Where Did My Parameters Go?

Author

  • Michelle Song
    Michelle Song

    View all posts

    • Categories

      • Awards & Recognition
      • Financial Close & Consolidation
      • FP&A Done Right
      • IBM Planning Analytics Tips & Tricks
      • News & Events
      • Success Stories
      • Tech Bulletins
      • Workday Adaptive Planning Insights
      • Workday Adaptive Planning Tips & Tricks

    Popular Posts

    Authors

    Adam Riskin
    Adam Riskin
    Ailenette Cruz
    Ailenette Cruz
    Alex Goldman
    Alex Goldman
    Ben Alcock
    Ben Alcock
    Brian Combs
    Brian Combs
    Dave Miersch
    Dave Miersch
    Dillon Rossman
    Dillon Rossman
    Gary Leiffer
    Gary Leiffer
    John Pra Sisto
    John Pra Sisto
    Ken Wolf
    Ken Wolf
    Koury Reid
    Koury Reid
    Lee Lazarow
    Lee Lazarow
    Lisa Minneci
    Lisa Minneci
    Marc Assenza
    Marc Assenza
    Mary Luchs
    Mary Luchs
    Michelle Song
    Michelle Song
    Nina Inverso
    Nina Inverso
    Revelwood
    Revelwood
    Robert Nordhagen
    Robert Nordhagen
    Tara Byrnes
    Tara Byrnes
    Wesley DeMarco
    Wesley DeMarco

    Sign up for our newsletter

    Connect

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

Contact:

25B Vreeland Road, Suite 111 Florham Park, NJ 07932
201.984.3030
info@revelwood.com

Copyright © 2023 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.