on 01-17-2017 11:17 AM
Hi All,
I am implemented an YearToGO custom measure, I need to set a value equal to last month of an year (e.g. year 2017 I need 2017 december)
I am trying to use TAIL function but when I add the custom measure in the report the data area became blank.
I have tested the code on T-code MDXTEST and it is working fine.
Following the code (only the part with tail function):
IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",
TAIL([%TIME%].[LEVEL01],1)
Thanks
Nilla
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try the following for AST:
'([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME_PL%].[LEVEL00]))';SOLVE_ORDER=3
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes sorry you are write, I put
TAIL([%TIME_PL%].[LEVEL01],1)
it was a wrong copy and paste.
but with this instruction when I add the custom formula the report became empty.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
But what do you mean by:
TAIL([/CPMB/MOD19WI].[LEVEL01],1)
Has to be:
TAIL([%TIME_PL%].[LEVEL01],1)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ok sorry, please find below the full code
IIF([%FUNCT_ACCOUNT_PL%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC", SUM(PERIODSTODATE([%TIME_PL%].[LEVEL00], CLOSINGPERIOD([%TIME_PL%].[LEVEL00])),-[MEASURES].[/CPMB/SDATA])-SUM(PERIODSTODATE([%TIME_PL%].[LEVEL00], [%TIME_PL%].CURRENTMEMBER),-[MEASURES].[/CPMB/SDATA]), IIF([%FUNCT_ACCOUNT_PL%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP", SUM(PERIODSTODATE([%TIME_PL%].[LEVEL00], CLOSINGPERIOD([%TIME_PL%].[LEVEL00])),[MEASURES].[/CPMB/SDATA])-SUM(PERIODSTODATE([%TIME_PL%].[LEVEL00], [%TIME_PL%].CURRENTMEMBER),[MEASURES].[/CPMB/SDATA]), IIF([%FUNCT_ACCOUNT_PL%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",
TAIL([/CPMB/MOD19WI].[LEVEL01],1),
IIF([%FUNCT_ACCOUNT_PL%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ", NULL, -[MEASURES].[/CPMB/SDATA])))) ';SOLVE_ORDER=3
Following the expected result.
The formula for EXP is fine
But For AST we need to have the last value of the year. The AST account is used to store the FTE.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please explain what do YOU mean by YearToGO measure with some example screenshot!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.