Macro issue: Current Year and Current Year +2

[Former Member]

Hi Macro experts

I have a view in monthly buckets. I like to copy values for one KF to another from current year to only Current year + 2. I have made following macro but it dosen't work:

AT: Initiate Input Row

Copy Sales FC to Al FC Input Y+2 : ( 24 Iterations : M 03.2009 ; M 02.2011 )

IF

Check year

YEAR( DATE(

Row: Customer Forecast ( Frm M 03.2009 )

) )

=

(YEAR( DATE( TODAY ) )

+

2

)

Row: Annual Target Input ( Frm M 03.2009 ) =

Row: Sales Forecast ( Frm M 03.2009 )

ENDIF

I get following message when I do the check:

Fehlerhafter logischer Ausdruck "(YEAR( 4D4HPL3ENNRMKCXE1NULTI4LX ) + 2 )":

Please help (If there is an easier way to make the macro please let me know)

Thanks

Sun

[Former Member]

Hey if you have a rollong period dataview then you can simplt specify the user defined periods from current year to current year + 2 at the step level.

This macro periods will also keep rolling as the dataview moves forward

[Former Member]

Hi

Thanks for the answer. It is a rolling period dataview. I understand you suggest the macro as:

AT: Initiate Input Row

Copy Sales FC to Annual FC Input Y+2 : ( 24 Iterations : M 03.2009 ; M 02.2015 )

Row: Annual Target Input ( Frm M 03.2011 ) =

Row: Sales Forecast ( Frm M 03.2009 )

But the problem is that when it is rolling period it will then also copy values in current year+3 and that is not acceptable. That is why I canu2019t use this macro. Values in current year (jan. month to dec. 2009) to (jan. month to dec. 2011)

Br

Sun

[Former Member]

Hi

I have solved the iisue by this macro:

AT: Initiate A Inpu

Copy Sales FC to Annual FC Input Y+2 : ( 24 Iterations : M 03.2009 ; M 02.2014 )

IF

Check year

YEAR( BUCKET_BDATE(

Row: Customer Forecast ( Frm M 03.2009 )

) )

=

YEAR( TODAY + 730 )

Row: Annual Target Input ( Frm M 03.2009 ) =

Row: Sales Forecast ( Frm M 03.2009 )

ENDIF

Br

SUN