## TM1 Function for Excel, TM1RPTELLEV

### TM1RPTELLEV returns an element’s level relative to the root in the subset.

**Where can the TM1RPTELLEV****function be used?**Excel

**What is the TM1RPTELLEV****function?****TM1RPTELLEV** returns an element’s level relative to the root in the subset.

**What is the syntax for TM1RPTELLEV?**TM1RPTELLEV(RptRowFormula, Element)

RptRowFormula = an absolute reference to the formula TM1RPTROW, a Dynamic Report function

Element = an element returned from TM1RPTROW

**TM1RPTELLEV****A demonstration on how to use**Determine the level for each element on the row set from a **Dynamic Report** using the **Product Scorecard** cube.