Total to next row

[krimya]

I am using CE 10 with oracle database.
The out put of the data table will be ID and End Balance and I have to input o as begin balance. The total is beginbal + end bal.
for the next row the begin balance = Total.
This will continue till end of the records.

ID Begin Balance End Balance Total
1 0 100 100
2 100 200 300
3 300 (100) 200
4 200 200 400
How to accomplish this.

 

[goranm]

Hi !

Maybe this can help you.

Create two different formulas:

@TotalBalance
NumberVar Total := Total + {YourTable.EndBalance};

@BeginBalance
if OnFirstRecord then
0
else
previous({@TotalBalance})

/Goran