TM1RPTELLEV

TM1RPTELLEV returns an integer value representing a member level within a hierarchy. This function is used in Dynamic Reports.

Syntax

TM1RPTELLEV(RptRowFormula, RowHeaderCell)

Argument

Description

Required/Optional

RptRowFormula

An absolute reference to a cell that contains a TM1RPTROW formula.

Required

RowHeaderCell

A relative reference to a cell that contains a member from the TM1RPTROW formula.

Required
Note: In the current release, TM1RPTELLEV and ELLEV are equivalent. Both functions return the level of a member based on the dimension.

Example

TM1RPTELLEV($B$25,$B25)