• Skip to main content
  • Skip to primary sidebar
  • 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

Lee Lazarow

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel YEARFRAC

 

I often build models that define the fraction of a year for a given month. For example, January is approx. 8.5% of a calendar year (31/365) and September is approx. 11.5% of a working day’s calendar (30/260). But what happens in situations…

Read More

March 14, 2023

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel EOMONTH

 

Thirty days has September … Do you sing that out loud every time you want to determine the number of days in a month? If so, do you have to pause and think about the end when defining the last day of…

Read More

February 21, 2023

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel TEXTSPLIT

 

Have you ever needed to parse a text string into different columns in Excel? This is easy to do via the text-to-columns wizard, but what if you wanted to do this via a formula? The TEXTSPLIT function allows you to split a…

Read More

February 7, 2023

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER

 

A while back, I wrote a blog about using Excel to manipulate text. The functions in that blog allow you to rip text apart and put the pieces together so you can parse out pieces of your text strings. Since that writing,…

Read More

December 13, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel SEQUENCE

 

Have you ever needed to quickly generate a list of numbers? Maybe you need to create a list from 1-100. Maybe you want to create a list of the first 100 even numbers. Maybe you want to create those same lists in…

Read More

November 22, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: PAW Go To Line in Process

 

Sometimes your TurboIntegrator scripts can become very long. While it’s nice to be able to scroll up and down throughout your code, there are times that you may want to go directly to a specific line. IBM Planning Analytics Workspace (PAW) version…

Read More

November 15, 2022

FP&A Done Right

FP&A Done Right: Approaches to Long-Term Planning

 

“If you fail to plan, you are planning to fail.” – Ben Franklin In our collective rush to react to ever-changing marketplace dynamics and shifts in the economy, it’s easy to focus on short-term plans, to the neglect of long-term planning. Today’s…

Read More

November 14, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Borders in Preview

 

IBM Planning Analytics Workspace (PAW) allows you to easily create selector widgets that can be used for updating the data in your PAW book. This is done by adding a dimension as a selector widget. You can edit the list of elements…

Read More

November 1, 2022

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips &Tricks: Rounded Buttons in Planning Analytics Workspace

 

IBM Planning Analytics Workspace (PAW) allows you to easily create buttons that can be used for navigation and to run TurboIntegrator (TI) scripts. This is done by dragging the Action Button widget onto the sheet. By default, the button appears as a…

Read More

October 25, 2022


VIEW MORE ARTICLES >

1 2Next Page » 16

Primary Sidebar

  • 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.