on 11-29-2017 10:36 PM
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
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.