TM1: Active Form Alternative Row Colours

A useful method to visually assist users in dissecting and viewing large amounts of rows of information in a TM1 report is having alternative row colours. This can be implemented quickly and easily using conditional formatting and combining two simple MS Excel functions.

The conditional formatting is performed in the Format Area of the Active Form.

TM1: Active Form Alternative Row Colours | QMetrix

TM1 Active Form Format Area

Depending on the row definition (0, 1, 2, D, N) that you want to colours to alternate on, select the row and column to apply the conditional formatting.

active form 1

Excel Conditional Formatting for row Definition 0.

The Excel formula ISODD() and ROW() is combined and will return TRUE if the row number is odd or FALSE if the row number is even. Click the Format… button and select the colour you want to apply for odd numbered rows.

active form 2

TM1 Active Form with alternative row colours.

When the Active Form is reloaded, the report will apply the conditional formatting and alternate the row colours to make viewing the report easier.


Get more TM1 Tech Tips here.

Learn how QMetrix can assist your organisation with IBM Planning Analytics (TM1).

Related Articles

QMetrix is ISO/IEC 27001 certified: Information Security Management System

QMetrix is pleased to announce we are now ISO/IEC 27001 certified, demonstrating our commitment to information and data security. Highlighted by various data breaches in recent times, cyber threats and criminal activities are on the rise. It is paramount for organisations to uphold high security standards and manage cyber-risks even before they occur in order

QMetrix is named 2024 APJ Workday Adaptive Planning Partner of the Year

QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner  of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage

Stay in touch

Get the latest insights from QMetrix straight in you inbox.

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information

Skip to content