TM1 Function for Excel, TM1RPTELISEXPANDED
TM1RPTELISEXPANDED returns a boolean value if an element is expanded on the row set.
Where can the TM1RPTELISEXPANDED function be used?
Excel
What is the TM1RPTELISEXPANDED function?
TM1RPTELISEXPANDED returns a boolean value if an element is expanded on the row set. Used for Dynamic Reports (Active Form).
What is the syntax for TM1RPTELISEXPANDED?
TM1RPTELISEXPANDED(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 TM1RPTELISEXPANDED
In a Dynamic Report, identify elements that are expanded and not expanded using a view from the Product Scorecard cube.