Skip to Content
0

Custom measure formula with user defined dimension parameters

Nov 29, 2017 at 10:36 PM

22

avatar image
Former Member

Hi experts,

I'm trying to set up a custom measure that will not only take parameter from the Account and Time dimensions, but also a property from the Flow dimension, here is how it looks:

IIF([%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="INC" OR [%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="EXP",MEASURES.[SIGNEDDATA],IIF([%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="AST" OR [%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="LEQ",IIF([%FLOWDIM%].CURRENTMEMBER.PROPERTIES("FLOW_TYPE")="Opening",(MEASURES.[SIGNEDDATA],OPENINGPERIOD([%TIMEDIM%].[%TIMEBASELEVEL%])),IIF([%FLOWDIM%].CURRENTMEMBER.PROPERTIES("FLOW_TYPE")="Closing",(MEASURES.[SIGNEDDATA],CLOSINGPERIOD([%TIMEDIM%].[%TIMEBASELEVEL%])),MEASURES.[SIGNEDDATA])),MEASURES.[SIGNEDDATA]))

I can save and process the formula, but the result is "empty" for "AST" and "LEQ" Accounts, not sure if its not possible or I have a syntax error, I haven't found anything useful so far, please advise

P.S. Using BPC 10 MS

Thanks,

William

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

0 Answers