Skip to Content

BPC MS GET function

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers