Change marked row values

[Former Member]

Hi experts,

In APO DP planning book I want to build a macro that changes the values (example : put to 1) of the marked row.

Do you know how to do this ?

Thanks in advance.

[Former Member · Accepted solution]

Hi,

There is a function called MARKED_ROW() or MARKED_ROW which will help you to determine, which row(s) are marked and based on that you can populate whatever values you would want for it.

Hope this helps.

Thanks & Regards

Mani Suresh

[Former Member · Accepted solution]

Thanks for your answer.

I already now this function, it returns a line number.

How can I modify values based on this line number ?

Thanks in advance.

[Former Member · Accepted solution]

Hi,

You will have to check for each row in your planning book. For whichever row a 1 is returned, it means that row is marked. Based on this test result, you can go ahead and change the values. I am assuming that you know what to change already.

So if the test returns 1. In the next line you can say Row Name = <value>. If it returns 0, it means the row is not selected and keep moving.

Hope this helps.

Thanks & Regards

Mani Suresh.

[Former Member · Accepted solution]

Thanks again,

I can't because I work at a drill down level. So I don't want to change the total line value but the selected sublevel line.

The function CLEAR() works with the line number and put all values to 0.

I would like to put other values. Do you know any mean to do that?