total column

[Former Member]

hello,

In a DP planning book, I would like to get total on every KF but on a visual column. Let's take an example :

W1 W2 W3 W4 total W5 W6 W7 W8 total

10 10 20 50 90 30 30 40 50 150

Could we use the macro ?

If anybody has this issue ?

Thanks very for your help

Pascale

[Former Member]

carlepas,

Sadly there is no way to get a column. What you can do is create an auxilliary row for the KF you wish to add after every 4 weeks. This row will basically have 4 weeks summation values for the KF to be added. You can work on the following lines :

Variable SUM = 0

Auxilliary Row Y (KF to display results)

Key Figure X (KF to be added)

STEP1: ITERATIONS (Throughout entire horizon)

IF ( MOD ( WEEK ( BUCKET_BDATE( <KF X> ) ) / 4) <> 0 )

THEN

SUM = SUM + X

ELSE

KF Y = SUM

SUM = 0

ENDIF

Hope this helps.

Regards,

Abhi

[Former Member]

carlepas,

Not really. SCM feature closest to your requirement is this:

You can use the "period-structure" icon (looking like calendar) on the planning book & select "Years" to get yearwise totals.

BR,

SB.