I just ran into an issue when TM1RPTELISCONSOLIDATED does not work in PAX dynamic report. It does not recognize the level of the referenced element and sets all elements to either Leaf or 0 based on the first element in the subset.
I tried deleting all rows except of the first one and rebuilding the sheet, calculating the formula on the side. It looks like it does not recognize a hierarchy. If I recreate the report from the scratch, the formula works. Is there anything that can be done to fix it in the existing report? It's very large and complicated, and will be a pain to rebuild.
TM1RPTELISCONSOLIDATED function does not work
-
- Regular Participant
- Posts: 346
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: TM1RPTELISCONSOLIDATED function does not work
Hi,
a bit, well a lot, more information might help. For a start, you could show us the actual formula!
Maren
a bit, well a lot, more information might help. For a start, you could show us the actual formula!
Maren