Skip to Content
avatar image
Former Member

EPMSelectMember Property Range

Hello

Wondering if you can help. I am trying to achieve 2 things using the EPMSelectMember formula with dimension TIME.

The aim is to have the user double click on a specific cell that then opens up the EPM - Member Selector pane and then they select a TIME that is restricted to a certain range (e.g. 2006.01 to 2025.12).

Going a step further I really want to have two separate cells (one for year and other for month), restrict both cells to a range and do this using the EPMSelectMember formula. Right now, I can restrict it to only one year or say one month in the EPM formula. Is there say an AND / OR option that combined with property and restricts to a range?

Hope this has made sense.

Thank you in advance,

Dru

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 14, 2017 at 10:45 AM

    Requirements not clear...

    But OR can be used like here:

    =EPMSelectMember(;"2017.01";"YEAR=2015;YEAR=2016;YEAR=2017";"TIME";FALSE)

    ";" = "OR"

    P.S. You can't use:

    ">","<"...

    YEAR=2015,2016,2017 (multiple values)

    Add comment
    10|10000 characters needed characters exceeded