Cumulative for key figure 0Amount

[Former Member]

Hi experts,

Who know how to create a cumulative key figure 0Amount in BPS BW?

My scenario is as follow:

If I populating a key figure called ' Headcount' for calender year/month E.g. 01.2008-12.2008 and input number in 0Amount. How to show the cumulative number of headcount in the 12 months period? Normally it only show monthly figure only.

Need your help.

I will assign full point.

Regards

CK

[former_member200574 · Accepted solution]

Hi,

If you want to see cummulative value in layout, you can use Totals in the layout. Anyway you are displaying the 12 month headcount in layout, add another column in your layout with an addition formula.

Regards,

KT

[Former Member]

Hi friend,

Thanks for your info. First of all I would like to know whether enhanced layout function in 'Setting for Planning Services' is applied for Web interface planning? Because after I changed the layout setting it did not reflect the settings in BPS planning layout (Excel format) which is created in BPS workbench.

Actually if the layout was created with key figures in row and 0Amount in month, is not possible to created a column with formula unless characteristic(Chart of account) in row. My objective is to create a key figure as culmulative month which can be set formula to accumulate the monthly figure in 0Amount.

Do you have a idea on this?

Regards

CK

[Former Member]

Hi Chek Keong,

I have similar requirements to enter plan data in cumulative values for each month in a fiscal year. Have you able to resolve your problem now. If yes, could you please advice me how.

Thanks

Stanley

[Former Member]

Hi Stainley,

I am assume you are using BW-BPS for planning. You can create a new key figure called 0CULAMT, description 'Cumulative YTD' . Then, you have to create a fox formula to compute the cumulative amount for 0Amount. The formula is look like this:

DATA CAL TYPE 0CULAMT.

DATA ACC TYPE ZACCT_R.

DATA PRD TYPE ZPRD_D.

FOREACH ACC, PRD.

{CULAMT, 200801, ACC, PRD} = {0AMOUNT, 200801, ACC,PRD}.

{CULAMT, 200802, ACC, PRD} = {CULAMT, 200801, ACC, PRD}+

{0AMOUNT, 200802, ACC,PRD}.

{CULAMT, 200803, ACC, PRD} = {CULAMT, 200802, ACC, PRD}+

{0AMOUNT, 200803, ACC,PRD}.

{CULAMT, 200804, ACC, PRD} = {CULAMT, 200803, ACC, PRD}+

{0AMOUNT, 200804, ACC,PRD}.

{CULAMT, 200805, ACC, PRD} = {CULAMT, 200804, ACC, PRD}+

{0AMOUNT, 200805, ACC,PRD}.

{CULAMT, 200806, ACC, PRD} = {CULAMT, 200805, ACC, PRD}+

{0AMOUNT, 200806, ACC,PRD}.

{CULAMT, 200807, ACC, PRD} = {CULAMT, 200806, ACC, PRD}+

{0AMOUNT, 200807, ACC,PRD}.

{CULAMT, 200808, ACC, PRD} = {CULAMT, 200807, ACC, PRD}+

{0AMOUNT, 200808, ACC,PRD}.

{CULAMT, 200809, ACC, PRD} = {CULAMT, 200808, ACC, PRD}+

{0AMOUNT, 200809, ACC,PRD}.

{CULAMT, 200810, ACC, PRD} = {CULAMT, 200809, ACC, PRD}+

{0AMOUNT, 200810, ACC,PRD}.

{CULAMT, 200811, ACC, PRD} = {CULAMT, 200810, ACC, PRD}+

{0AMOUNT, 200811, ACC,PRD}.

{CULAMT, 200812, ACC, PRD} = {CULAMT, 200811, ACC, PRD}+

{0AMOUNT, 200812, ACC,PRD}.

ENDFOR.

[Former Member]

Hi Stainley,

I am assume you are using BW-BPS for planning. You can create a new key figure called 0CULAMT, description 'Cumulative YTD' . Then, you have to create a fox formula to compute the cumulative amount for 0Amount. The formula is look like this:

DATA CAL TYPE 0CULAMT.

DATA ACC TYPE ZACCT_R.

DATA PRD TYPE ZPRD_D.

FOREACH ACC, PRD.

{CULAMT, 200801, ACC, PRD} = {0AMOUNT, 200801, ACC,PRD}.

{CULAMT, 200802, ACC, PRD} = {CULAMT, 200801, ACC, PRD}+

{0AMOUNT, 200802, ACC,PRD}.

{CULAMT, 200803, ACC, PRD} = {CULAMT, 200802, ACC, PRD}+

{0AMOUNT, 200803, ACC,PRD}.

{CULAMT, 200804, ACC, PRD} = {CULAMT, 200803, ACC, PRD}+

{0AMOUNT, 200804, ACC,PRD}.

{CULAMT, 200805, ACC, PRD} = {CULAMT, 200804, ACC, PRD}+

{0AMOUNT, 200805, ACC,PRD}.

{CULAMT, 200806, ACC, PRD} = {CULAMT, 200805, ACC, PRD}+

{0AMOUNT, 200806, ACC,PRD}.

{CULAMT, 200807, ACC, PRD} = {CULAMT, 200806, ACC, PRD}+

{0AMOUNT, 200807, ACC,PRD}.

{CULAMT, 200808, ACC, PRD} = {CULAMT, 200807, ACC, PRD}+

{0AMOUNT, 200808, ACC,PRD}.

{CULAMT, 200809, ACC, PRD} = {CULAMT, 200808, ACC, PRD}+

{0AMOUNT, 200809, ACC,PRD}.

{CULAMT, 200810, ACC, PRD} = {CULAMT, 200809, ACC, PRD}+

{0AMOUNT, 200810, ACC,PRD}.

{CULAMT, 200811, ACC, PRD} = {CULAMT, 200810, ACC, PRD}+

{0AMOUNT, 200811, ACC,PRD}.

{CULAMT, 200812, ACC, PRD} = {CULAMT, 200811, ACC, PRD}+

{0AMOUNT, 200812, ACC,PRD}.

ENDFOR.

[Former Member]

Hi,

I think the best solution is to use keyfigure 0BALANCE to store the values and it will automatically display it for 12 periods.

If 0BALANCE is not a solution then create your own key figure and in the tab aggregation select aggregation as SUM and Exception Aggregate as Last Value and Agg. Referen. Char as 0FISCPER. Transaction code RSD3.

thanks

[Former Member]

Hi Chek Keong,

yes, I am using the BW-BPS for planning. Thanks for the FOX. It works.

Appreciated your response and answer.

Cheers,

Stanley Cheong

[Former Member]

Hi friend,

Thanks for your info.

Can you elaborate more detail on 'how to add another column in your layout with an addition formula' ? I am not exactly know what you means.

Regards

CK

[Former Member]

Hi CK,

You could add a Formula column to your layout using the transaction UPX_MNTN for enhanced layouts. make sure you select the correct planning area in UPXA before.

hope it helps