column count and accumulate

[Former Member]

t

     Hi, good day,  i need your help!  i can not find the answer, i think is easy for you.   I have a table with payment so i need a new column or formula to accumulate and count for the column Payment.   how can do it? 

Original Table:

Name	Payment
juan perez	100
pancho villa	200
emiliano zapata	300
juan gabriel	400

Result needed:

Name	Payment	Accumulate	Count
juan perez	100	100	1
pancho villa	200	300	2
emiliano zapata	300	600	3
juan gabriel	400	1000	4

thank you for all your advices.

[abhilash_kumar · Accepted solution]

Hi,

Here's what you need to do:

1) Go to the Field Explorer > Right-click "Running Total Fields" and select "New"

2) In the Running Total Wizard, choose the Payment Field as the "Field to Summarize"

3) Make sure "For each record" is selected for "Evaluate" and "Never" for "Reset".

4) Place the Running Total field beside Payment

To see the count, create another Running Total field. Choose the same field as the "Field To Summarize" and instead of sum choose "count" from the drop-down. Rest of the options remain the same.

Let me know how this goes!

- Abhilash

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member · Accepted solution]

thank you very much!