Excel Functions

TM1 Function – TM1RPTISCONSOLIDATED

Available In

Excel

Definition

TM1RPTELISCONSOLIDATED returns a Boolean value if an element is consolidated.

Used for Dynamic Reports (Active Form).

Syntax

TM1RPTELISCONSOLIDATED(RPTROWFORMULA, Element)

RPTROWFORMULA = an absolute reference to the formula TM1RPTROW, a dynamic Report function
Element = an element returned from TM1RPTROW

Example

In a Dynamic Report, identify elements that are consolidated and not consolidated.

TM1RPTELISCONSOLIDATED appears on each row in Column A. The result from this function is used in an IF condition to obtain each element’s level.

TM1RPTELISCONSOLIDATED on All Products returns TRUE.

TM1RPTELISCONSOLIDATED on Bike Racks returns FALSE.


Video Demo