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
#REF - means the error in the formula like non existing reference.
why then have it as a parameter in the EPMMemberProperty?
The #REF! error shows when a formula refers to a cell that's not valid. It's a standard excel error.
P.S. I suspect that you are referencing some report cell of the dynamic epm report...
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
Sorry, but you need some Excel training...
EPMMemberProperty("This_Model",AB11,"ACCOUNT") - can return "#Error" if there is no connection or some other cases
SEARCH("#Error",EPMMemberProperty("This_Model",AB11,"ACCOUNT")) will return 1 if "#Error" is found or Excel error "#VALUE!"
ISERROR(SEARCH("#Error",EPMMemberProperty("This_Model",AB11,"ACCOUNT"))) will return TRUE if "#Error" is NOT found and FALSE if found