Skip to Content
avatar image
Former Member

FORMULA EPMMEMBERPROPERTY ERROR EXCEL 2016 10,1 CLASSIC NW

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 16, 2017 at 12:21 PM

    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")

    Add comment
    10|10000 characters needed characters exceeded