Skip to Content
0
Former Member
Oct 24, 2013 at 06:33 AM

*For/*next related In SAP BPC NW Version

83 Views

Hi Everyone,

My Requirement as follows,

Account
2007.02(Input Form) 2008.02
2009.02
2010.02
2011.02
----------

BS111

20 40 80 160 320 BS112 10 20 40 80 160

2007.02 Actual/Is, based on the Actual value we need to calculate the remaining years(The Actual value is calculated for only FEB )

For this requirement I wrote logic like as follows

*FOR %VAR%=TMVL(12,%TIME_SET%),TMVL(24,%TIME_SET%),TMVL(36,%TIME_SET%),TMVL(48,%TIME_SET%)

*WHEN ACCOUNT

*IS *

*WHEN TIME

*IS %VAR%

*REC(FACTOR = 2,CATEGORY = Actual,TIME = TMVL(12,%VAR%))

*ENDWHEN

*ENDWHEN

*NEXT

For the Above code I will get the output like this

Account
2007.02
2008.02
2009.02
2010.02
BS111 10 20 20 20 BS112 20 40 40 40

Note:User selects Dynamically, Based on selected year he need to calculated next 10 years.

Thank you,

Regards,

Saidareddy.G