TM1RPTELISCONSOLIDATED function does not work

Post Reply
VV_VV
Posts: 6
Joined: Wed Oct 14, 2015 1:49 am
OLAP Product: Planning Analytics
Version: 2.0...
Excel Version: 2016

TM1RPTELISCONSOLIDATED function does not work

Post by VV_VV »

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.
MarenC
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

Post by MarenC »

Hi,

a bit, well a lot, more information might help. For a start, you could show us the actual formula!

Maren
Post Reply