TM1RPTELLEV function#
TM1RPTELLEV returns the display level of an Active Form row - used for level-based indentation and formatting within the region.
TM1RPTELLEV is part of the native TM1 Active Form family. It is normally generated by Planning Analytics for Excel rather than typed by hand.
Signature#
=TM1RPTELLEV(rptRowCell, element)
Arguments#
| # | Argument | Type | Required | Permitted values and notes |
|---|---|---|---|---|
| 1 | rptRowCell |
Range | Yes | A reference to the region's TM1RPTROW cell. |
| 2 | element |
String | Yes | The row element to read. |
The default result is 0.
Notes and limits#
- Before the Active Form region has been processed, the function returns
0.
Related pages#
- IBM Planning Analytics functions - the function index and the shared error model.
- TM1RPTELISCONSOLIDATED function - test whether a row is a consolidation.
Feedback on this page
Comments, questions, requests, or something missing or unclear? Email us - the page you are on is filled in for you.
Email feedback on this pageOr write to support@reportworq.com directly.