Hi BPC gurus,
I'd like to make a condition in my scriptlogic for an allocation of a planned value on year base to the months values. If there is reference data in the past year, I would like to allocate according to the reference. If not, I would just like to make an even distribution. Unfortunately I didn't find a way to use variables in scriptlogic and assign values to them. Here's my coding:
*LOOKUP Vertrieb
*DIM MEASURES="PERIODIC"
*DIM CATEGORY="ACTUAL"
*DIM P_DATASRC="UPLOAD"
*DIM PREVYEAR:TIME="2009.TOTAL"
*DIM PREVJAN:TIME="2009.JAN"
*DIM PREVFEB:TIME="2009.FEB"
...
*ENDLOOKUP
*WHEN TIME
*IS "2010_INPUT"
*WHEN CATEGORY
*IS "PLAN"
*WHEN P_DATASRC
*IS "MANUAL"
//here I would like to add a condition if the value for the past year is not 0
*REC(FACTOR=LOOKUP(PREVJAN)/LOOKUP(PREVYEAR),TIME="2010.JAN")
*REC(FACTOR=LOOKUP(PREVFEB)/LOOKUP(PREVYEAR),TIME="2010.FEB")
...
//or here I would like to add a condition if the value for the past year = 0
*REC(FACTOR=1/12,TIME="2010.JAN")
*REC(FACTOR=1/12,TIME="2010.FEB")
*ENDWHEN
Thanks for your assistance.
Regards,
Ulrike