Limiting the Scope of Calculated Accounts

August 20, 2025

Both modeled and cubed sheets in Workday Adaptive Planning allow the user to set a scope to limit the calculation for calculated accounts for both actuals and planned data. A user may utilize this feature to allow calculations to start at a certain point, without having to alter the actuals or plan version start date.

In order to limit the scope of the calculated accounts, you will begin by navigating to the back end of the sheet and go to columns and levels. Once you are at columns and levels, you can press the sheet properties gear in the middle of the screen.

Once you have navigated to the sheet properties, press the last tab that is titled “Scope.” This is where you will have the option to limit the scope for calculated accounts.

You now have the ability to set the scope either forward or backwards for actual values or plan values as well. For the actuals, the drop down for the start/stop calculating gives you an option to select start/end of version, month, quarter, year. For the plan, the drop down for start/stop gives you the option of left scroll limit, end of plan, month, quarter, year.

In the example above, we set the scope so that the plan values do not start until 6 months after the start of the plan. As you can see from the start date, it should start 1/1/2025, but from the row details we can see that the calculations do not begin until July.

Revelwood is more than just a Platinum Workday Adaptive Planning partner — we’re a trusted advisor to the Office of Finance. With 30 years of experience and award-winning expertise, we bring together powerful software, proven best practices and pre-built, ready-to-deploy solutions that accelerate time to value. Our team doesn’t just implement technology — we help finance teams transform the way they plan, analyze and make decisions. Discover how Revelwood can help you get the most out of Workday Adaptive Planning — and achieve results that matter.

Author

Revelwood

View all posts