Skip to Content
avatar image
Former Member

Cumulative for key figure 0Amount

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2007 at 01:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 23, 2007 at 10:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Aug 24, 2007 at 03:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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