The Number 1 independent website for ACL information!

TexasACL User Group
About Us
Training
Why ACL
Essays & Scripts
ACL News
Events
Links
FAQ
Site Map
Support Us
A running total is  a field that accumulates values by adding the current value with a previous total:
Transaction Date
Amount
 Jan  1
50
Feb 1
60
Mar 1
45
Apr 1
35

The running total field will accumulate the total in the amount field.

 Transaction Date
AmountRunning Total
Jan 150
50
Feb 1
60
110
Mar 1
45
155
Apr 1
35
190

In order to create the field "Running Total" one has to use a script:


COM****************************************************************
COM This is a standard running total script.
COM****************************************************************

OPEN tablename

ASSIGN v_running_total =0.00

GROUP
v_running_total = v_running_total + amount
EXTRACT FIELDS ALL v_running_total as "F Running Total" TO TEMP1
END