TM1RPTELISCONSOLIDATED function#
TM1RPTELISCONSOLIDATED returns TRUE when an Active Form row element is a consolidation (or resolves to a subset) - used to format roll-up rows differently.
TM1RPTELISCONSOLIDATED is part of the native TM1 Active Form family. It is normally generated by Planning Analytics for Excel rather than typed by hand.
Signature#
=TM1RPTELISCONSOLIDATED(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 test. |
The default result is FALSE.
Notes and limits#
- Before the Active Form region has been processed, the function returns
FALSE. - If the referenced element resolves to an error value, the function reports an error for that cell.
Related pages#
- IBM Planning Analytics functions - the function index and the shared error model.
- TM1RPTELLEV function - the display level of an Active Form row.
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.