cancel
Showing results for 
Search instead for 
Did you mean: 

Copy Marked values forward Macro Logic

Former Member
0 Kudos

Hi APO-DP Guru's

I had a issue with DP-Macro, Macro is copy Marked values forward.

** Macros in the Macro Book**
  ** Copy Marked Values Forward**
    ** All : ( 1 Iterations :; )**
        **IF**
      ** act_column marked?**
          **COLUMN_MARKED( ACT_COLUMN ) = 1**
      ** Row: Custom Disaggregation Factor ( Frm  ) =*(2nd week)*
          **Row: Custom Disaggregation Factor ( Frm Offset 0 )*(1st week)*
        **ENDIF**This is the Macro i am using.

I am Marking(selecting) 3 weeks, i.e week 1, week 2, week 3, week 1 contains the value 20, when i executes this macro, it supposed to copy the value 20 to week 2, week 3 only, but it coping the 20 valu to week 2, week 3 and unmarked week 4 also.

Could any body tell me logic for this Macro urgently.

Thanks in advance.

Regards

Ravi Pradeep Raju P

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

you need to change the macro processing direction to backward...

immaterial of your not marking the 4th row it will copy 3rd row to 4th since it is an iterative step

or stop marking row 3 ... row 2 will anyhow be copied to row 3

srinivas_krishnamoorthy
Active Contributor
0 Kudos

Ensure you have the ELSE logic as well in your macro code. Confirm if that works.

Former Member
0 Kudos

Hi Sinivas, thanks for your reply, could you please tell me this macro related logice, initially i am using this macro logic, tell me if there are any updated logic to meet my requirement. this will help me a lot, thanks in advance.