TM1 Function for Excel, TM1RPTELISCONSOLIDATED

TM1RPTELISCONSOLIDATED Returns a boolean value if an element is consolidated.

Where can the TM1RPTELISCONSOLIDATED function be used?

Excel

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.