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 return always 0 in Activeform XLS
-
schlemiel29
- Posts: 68
- Joined: Tue May 08, 2012 8:29 am
- OLAP Product: TM/1
- Version: 11.8
- Excel Version: Excel 365
-
lotsaram
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: ELLEV return always 0 in Activeform XLS
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.
-
schlemiel29
- Posts: 68
- Joined: Tue May 08, 2012 8:29 am
- OLAP Product: TM/1
- Version: 11.8
- Excel Version: Excel 365
Re: ELLEV return always 0 in Activeform XLS
OMG! So simple! Thanks a lot, I forgot the "SERVER:". Now it works. 