Skip to Content
0
May 18, 2016 at 04:21 PM

How to display description

28 Views

Hello, For account description, I am using member recognition in conjunction with if,,else formula,, here is the exact formula

= EPMOlapMemberO(IF(O65="1","PL","BS"),"[ACCOUNT].[PARENTH1].[BS]","Balance Sheet","","000")

So currently O65 is 2, thats why it would display BS. I want it to actually display description not ID. what do i need to change in this formula so that I can get it to display description?

Thanks.