TM1 Function for Excel, TM1RPTELISCONSOLIDATED

TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated.

Where can the TM1RPTELISCONSOLIDATED function be used?

Excel

Which TM1 Server version is this function available for?

Version 11 and 12

What is the TM1RPTELISCONSOLIDATED function?

TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated.
Used for Dynamic Reports (Active Form).

What is the syntax for TM1RPTELISCONSOLIDATED?

TM1RPTELISCONSOLIDATED(RptRowFormula, Element)
RptRowFormula = an absolute reference to the formula TM1RPTROW, a dynamic Report function
Element = an element returned from TM1RPTROW

A demonstration on how to use TM1RPTELISCONSOLIDATED

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