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.