Skip to Content
0

EPMMemberProperty and #REF!

Aug 12 at 09:26 PM

47

avatar image

Hi All,

Can #REF! be used as a parameter in EPMMemberProperty?
Along the lines of EPMMemberProperty(A3,#REF!,A4)?
Does it look for a dimension member #REF?

Lucy

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

3 Answers

Vadim Kalinin Aug 13 at 08:13 AM
0

#REF - means the error in the formula like non existing reference.

Share
10 |10000 characters needed characters left characters exceeded
Lucy Reynolds Aug 14 at 08:25 AM
0

why then have it as a parameter in the EPMMemberProperty?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

The #REF! error shows when a formula refers to a cell that's not valid. It's a standard excel error.

0

P.S. I suspect that you are referencing some report cell of the dynamic epm report...

0
Lucy Reynolds Aug 15 at 08:42 AM
0

Ok here's another one..

I have this cell formula

=IF(AB11="","",IF(ISERROR(SEARCH("#Error",EPMMemberProperty("This_Model",AB11,"ACCOUNT"))),EPMMemberProperty("This_Model ",AB11,"ACCOUNT"),""))

I understand EPMMemberProperty("This_Model ",AB11,"ACCOUNT") returns the Account parameter value. But what is this bit below doing?

IF(ISERROR(SEARCH("#Error",EPMMemberProperty("This_Model",AB11,"ACCOUNT"))

Is it searching for #Error in the ACCOUNT parameter of the member housed in AB11?

Lucy

Share
10 |10000 characters needed characters left characters exceeded