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

Which TM1 Server version is this function available for?

Version 11 and 12

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.