• 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

IBM Planning Analytics Tips & Tricks

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

Tips & Tricks from Revelwood

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: PAW “Spacers”

 

Have you ever created an exploration in IBM Planning Analytics Workspace (PAW) that contains a lot of data and wish that you could separate the information? PAW allows you to insert blank rows and columns called “spacers” into your exploration. Here is…

Read More

March 19, 2024

IBM Planning Analytics Tips & Tricks

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

 

Most standard financial reports round to some form of a large value. For example, the report may show numbers in millions or rounded to the nearest 100,000. This is done in Excel via the ROUND function. The function has two parameters: =ROUND(number,…

Read More

March 5, 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: PAW Generated Statements

 

One of the great things about IBM Planning Analytics Perspective’s process editor is that the wizard can be used to create code within your scripts. The results of the wizard based statements are inserted within areas called “Generated Statements.” However, there may…

Read More

February 6, 2024

Tips & Tricks from Revelwood

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total

 

Pie charts are a type of visualization known as composition. Composition charts are designed to show the parts of a whole. This is a great way to look at the pieces of total. For example, the branches in a region or the…

Read More

January 23, 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

IBM Planning Analytics Tips & Tricks

Top Three IBM Planning Analytics Tips & Tricks Posts – 2023

 

What were your favorite IBM Planning Analytics Tips and Tricks blog posts this year? We took a look at our website analytics and found the top three posts of 2023 are (drumroll, please!) … IBM Planning Analytics Tips & Tricks: DefineCalc IBM…

Read More

December 19, 2023

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Using the Subset Editor in Planning Analytics Workspace

 

In the past, manipulating subsets in IBM Planning Analytics Workspace (PAW) involved a convoluted process of copying, creating new sets, and pasting elements. The subset editor solves this problem. The subset editor enables you to perform multiple tasks with a single click.…

Read More

December 12, 2023


VIEW MORE ARTICLES >

< Prev Page 6 7Next Page » 41

Primary Sidebar

  • Categories

    • Accounting and Accounts Receivable
    • Awards & Recognition
    • Data Analytics in Finance
    • Finance Transformation
    • 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.