Cumulative total please??? 1

[ombina]

Hello,

I am trying to calculate cumulative total:

Final output -
Col1 Col2
==== ====
1 1
2 3
3 6
4 10
5 15
.
.


Thanks,

Ricky

 

[synapsevampire]

You've 2 options, create a Running Total field which evaluates for every record and does not reset, and place it in the details.

Or

Create a formula like the following:

whileprintingrecords;
numbervar ThisValue :=ThisValue+{table.field}

-k

 

[LMRollins]

synapsevampire,

I have a similar post like this and your 2nd option worked great.

Thanks,
Lori