Skip to Content
0

EPMSelectMember Property Range

Jun 14, 2017 at 10:10 AM

42

avatar image

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

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

1 Answer

Vadim Kalinin Jun 14, 2017 at 10:45 AM
0

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)

Share
10 |10000 characters needed characters left characters exceeded