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
| Amount | Running Total
|
| Jan 1 | 50
| 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