TM1 Forum

In Excel I created a report as an active form. Works fine with dynamic rows and selection of header elements. I like to add an indicator, if a consolidated element is chosen in the header dimensions. So I tried to use ELLEV. This function returns always 0, even if it is a consolidated element. Is this function not designed to use it here? Is there a bug or a trick to get it work?
Best regards
Dirk

ELLEV definitely works. Most likely you are not referencing the dimension name as server:dimension. If you post the formula more likely someone can help you out.

OMG! So simple! Thanks a lot, I forgot the "SERVER:". Now it works.