• 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
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Ivan Cepero

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: PAW Settings – File Upload Action Button

 

Have you ever written a TurboIntegrator (TI) script that used a manually uploaded file as a source? If so, this requires a two-step process: upload the file and then run the script. As long as you remember to follow both steps, the…

Read More

May 27, 2025

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: PAW – Navigation Approaches Using Action Buttons

 

Have you ever been in a situation where you created a multi-tab IBM Planning Analytics Workspace (PAW) book that required a combination of inputs, TurboIntegrator (TI) processing, and the viewing of results?  If so, you may have created a two-part workbook that…

Read More

April 29, 2025

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel’s AGGREGATE Function

 

Excel’s AGGREGATE function lets you manage complex reports and ensure they foot correctly. For example, suppose you are building a sales report by product and region. Building the Grand Total calculation for a multi-level report like this is error-prone. You would need…

Read More

February 18, 2025

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Unpivot

 

Did you know you can unpivot data in IBM Planning Analytics? Sometimes you’ll find yourself in a situation where you need to change the layout of data from a grid format to a vertical table format, this is called unpivoting the data.…

Read More

January 21, 2025

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: VSTACK_HSTACK

 

In a previous blog, I wrote about the ability to convert a list into a set of smaller lists (create a link to the WRAPCOLS blog). But what if you wanted to do the opposite? What if you wanted to merge a…

Read More

July 30, 2024

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel’s WRAPCOLS Formula

 

Have you ever needed to modify a list in Excel without wanting to manually manipulate the data? Excel’s WRAPCOLS formula lets you reshape data without having to perform tedious copy and pasting. The syntax of the WRAPCOLS formula is: =WRAPCOLS(vector, wrap_count, pad_with)…

Read More

June 4, 2024

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips and Tricks: Excel’s ARRAYTOTEXT Function

 

Have you ever needed to export Excel data in a format that can be read by other systems?  Although csv files are widely accepted, many legacy systems expect data in an array format. This can be done using the ARRAYTOTEXT formula in…

Read More

April 2, 2024

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel Switch Function

 

The SWITCH function in Excel evaluates a condition and then provides a result based on that condition. This function is similar to a SQL CASE statement and allows for up to 126 potential results. The syntax of the SWITCH function is: =SWITCH(expression,…

Read More

February 20, 2024

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Excel TEXT Function

 

Have you ever merged text and a calculated number into a cell and saw that the format of the number was hard to read? The TEXT function in Excel lets you convert the number into a more professional format. The syntax of…

Read More

January 9, 2024


VIEW MORE ARTICLES >

1 2Next Page » 2

Primary Sidebar

  • Categories

    • Accounting and Accounts Receivable
    • Awards & Recognition
    • Data Analytics in Finance
    • 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
Brian Combs
Brian Combs
Cameron Burke
Cameron Burke
Dave Miersch
Dave Miersch
Ivan Cepero
Ivan Cepero
John Pra Sisto
John Pra Sisto
Jonathan Dunn
Jonathan Dunn
Julia Seelin
Julia Seelin
Ken Wolf
Ken Wolf
Lee Lazarow
Lee Lazarow
Lisa Minneci
Lisa Minneci
Luke Griffie
Luke Griffie
Marc Assenza
Marc Assenza
Mary Luchs
Mary Luchs
Michelle Song
Michelle Song
Revelwood
Revelwood
Robert Nordhagen
Robert Nordhagen
Sarah Hildenbrand
Sarah Hildenbrand
Simon Foley
Simon Foley
Thomas McDade
Thomas McDade

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

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

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