Skip to Content
avatar image
Former Member

Custom measure formula with user defined dimension parameters

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers