on 06-30-2017 4:47 AM
I have a question regarding long tuple usage.
I'd like to use a long tuple format, but also perform a time level offset.
For example
*WHEN CATEGORY
*IS FORECAST
*WHEN TIME
*IS %CURRENT_PERIOD%
*WHEN ACCOUNT
*IS INSTALLBASE
*REC(EXPRESSION=(%VALUE% + ([ACCOUNT].[INSTALLBASE],[CATEGORY].[ACTUAL],[TIME].[%CURRENT_PERIOD-1%])/2),ACCOUNT=NEWACCOUNT)
*ENDWHEN
*ENDWHEN
*ENDWHEN
I've tried string manipulation like is used in MS, I've tried using TMVL on the time portion of the tuple, nothing has worked. Has anyone found a good way to manipulate a time member of a long tuple formula?
Thanks!
Use TMVL.
[...]. [...], [TIME]. [TMVL(-1,%SINGLE_PERIOD_VARIABLE%)]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
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.