Skip to Content
0

FORMULA EPMMEMBERPROPERTY ERROR EXCEL 2016 10,1 CLASSIC NW

Nov 16, 2017 at 11:26 AM

53

avatar image
Former Member

Hi experts.

I have a report, with the following formula "=EPMMemberProperty(;"PLAN";"YEAR")" in excel 2016 does not show the value (appear empty), in excel 2013 this formula run correctly.

Thank you all.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Nov 16, 2017 at 12:21 PM
0

Try to use:

=EPMMemberProperty(;"[CATEGORY].[].[ACTUAL]";"YEAR")

Where CATEGORY is your dimension name and there is no hierarchy for this dimension.

P.S. Another option is to use this syntax:

=EPMMemberProperty(;"CATEGORY:ACTUAL";"YEAR")

Share
10 |10000 characters needed characters left characters exceeded