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

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