Skip to Content
0

BPC MS GET function

Jan 11 at 09:40 AM

26

avatar image

We have a input schedule simulating month forecasts based on actuals were script logic does the some of the calculation due to the number of values.

My Question is, is it possible to retrieve a specific month member saved as account value? The value format is TIMEID example Account1 where date value is 20171200.

Trying something like this were the users can change forecast date by them self.

This does not work, but can this be done in some other way.

*SELECT(%TID_X%,ID,TID,"TIMEID='GET(KATEGORI=BUDGET, Account1=DATE, CONTRACT=CONTRACT_NONE, TIME=9999.M, TYP=OTHER, PRODUCT=P1009S, PLINJE=PL_9999)'")

This works and will give 2017.DEC to use with *REC calculation but needs manual change in script *SELECT(%TID_X%,ID,TID,"TIMEID='20171200'"))

Best regards Tommy

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

0 Answers