Running Total Formula Help

[Former Member]

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?

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

awesome...... worked perfect.

Thank You