Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Running Total Formula Help

I am trying to subtract a list of numbers from a begining number.

Example... I have 480,000 parts...... I have a list of usage by week. I am trying to get a balance after each week.

Here is what I am trying to get

Starting 480,000

10/5/2008 10,000 470,000

10/12/2008 15,000 455,000

10/19/2008 5,000 400,000

ect.....

I am trying to get a formula to create my running total (shown in bold)

Any suggestions?

replied

Hi Travis,

try creating a formula like

@initialize:

whileprintingrecords;

numbervar i:=480,000;

place this in report header

and create one more like

@Evaluate:

whileprintingrecords;

numbervar i;

i:=i-;

Place this beside the amount field.

Regards,

Raghavendra

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question