Skip to Content
0
Former Member
Nov 14, 2008 at 08:14 PM

Macro problem, how to stop rolling

29 Views

Hi Guru,

I have a problem for the Macro in DP.

scenario: two key figure. A and B.

cell of B of bucket 11/17 is the sum of cell A of bucket 11/14,11/15, 11/16.

However, next day. the bucket 11/17 of cell B in the macro automatically rolls to 11/18. The reqmt is to prevent the time bucket from rolling for B in the macro. In other words, cell B in bucket 11/17 should never change. It should not be rolling automatically to 11/18. It should always equal to the sum of cell A of bucket 11/14,11/15, 11/16.

I tried many settings in the macro itself. e.g. user-defined, data-dependent, turn on and off of automatically column adjustment from-column, processing area, whole table, one bucket, multiple bucket.

The bucket of 11/14, 11/15, 11/16 for A is not rolling, but B of bucket 11/17 is still rolling.

HELP! Any input will be greatly appreciated.

Thanks,

Hai