• Skip to primary navigation
  • Skip to main content
  • Skip to footer
Revelwood

Revelwood

  • 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
      • Advisory Services
      • Customer Care
        • Help Desk
        • System Admin
        • Performance Tune-Up
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • PRODUCTS
      • DataMaestro
      • Lightspeed Planning & Reporting
      • IBM Planning Analytics Utilities
  • How We Help
    • Workday Adaptive Planning Use Cases
    • IBM Planning Analytics Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
    • User Groups
  • Contact Us

IBM Planning Analytics Tips & Tricks: Blank Rows in Active Form Reports

Did you know when creating active form reports, you may sometimes want to separate sections? Some people like to create this separation via dashes or via bold line formatting. Some prefer to create “dummy” elements and use conditional formatting to make them appear like a blank line (although this approach is not recommended). Many clients, […]

IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks: Blank Rows in Active Form Reports

 

Tips & Tricks

September 17, 2019

By Lee Lazarow

Did you know when creating active form reports, you may sometimes want to separate sections? Some people like to create this separation via dashes or via bold line formatting. Some prefer to create “dummy” elements and use conditional formatting to make them appear like a blank line (although this approach is not recommended). Many clients, however, prefer to have the separation via a blank line.

Unfortunately, there is no easy way to create a blank line. We instead used a different approach with a client to create separation within rows in an Excel-based report.

Here is a sample report that we will start with, including the formatting range:

IBM Planning Analytics Tips & Tricks: Blank Rows in Active Form Reports

Column 1 references the element level of the account. This is the column that will be used for the formatting. The rest of the report is a standard active form. 

We now want to insert a blank area above the level 1 elements (e.g., above the line for Interest and above the line for Taxes).

Step 1: Insert a new column and edit the formatting for the applicable level

  • We will insert a new column to the left of the year
  • We will then format the new column for level 1 to have a very large font.  This report is currently set to use font size 11, so we will set this one cell to use font size 22.

Here is the new formatting area:

Blank Rows in Active Form Reports

Step 2: Within the report, hard code a value into the new column

  • Type the letter X into the new column. Remember that you only need to put the letter into the top row since Active Forms will replicate the value when you rebuild the report.

Here is the report after rebuilding it:

IBM Planning Analytics Tips: Blank Rows in Active Form Reports

There are now blank areas surrounding the rows associated with level 1, but the new formatting is only associated with the one column. 

Step 3: Hide the new column

  • In addition to hiding the column, you may choose to also manipulate the vertical cell alignment.

Once completed, here is the final report that users will see:

IBM Planning Analytics Tricks: Blank Rows in Active Form Reports

This approach uses formatting to create separation between rows within Excel. When combined with conditional formatting and other references in the first column (e.g. the format definition column), this approach can be both very powerful and very flexible.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Learn more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: The Ranked Report

IBM Planning Analytics Tips & Tricks: Snap Commands – Spelling

IBM Planning Analytics Tips & Tricks: Snap Commands – Sorting

Need more guidance? Take a look at our IBM Planning Analytics Training services and our Customer Care Program.

    • Categories

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

    Popular Posts

    • Workday Adaptive Planning Tips & Tricks: The Formula Assistant – How To, Where & Why
    • Workday Adaptive Planning Tips & Tricks: Templates
    • IBM Planning Analytics Tips & Tricks: Troubleshooting Planning Analytics for Excel
    • Workday Adaptive Planning Named a Leader in Gartner Magic Quadrant for Cloud Financial Planning and Analysis Solutions 2020
    • Workday Adaptive Planning Tips & Tricks: Excel Reporting Using a Report Template

    Sign up for our newsletter

    Connect

    Authors

    • John Pra Sisto
    • Revelwood
    • Adam Riskin
    • Ailenette Cruz
    • Brian Combs
    • Dave Miersch
    • Dillon Rossman
    • Gary Leiffer
    • Ken Wolf
    • Koury Reid
    • Lee Lazarow
    • Lisa Minneci
    • Marc Assenza
    • Mary Luchs
    • Michelle Song
    • Nina Inverso
    • Summer Jeter
    • Tara Byrnes
    • Thanh Chau
    • Wesley DeMarco

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

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

Awards & Recognition

Adaptive Insights Named a Leader in the

Awards & Recognition

News and events

The GDPR and What This Means for You

News & Events