Running total

[garrys]

Hi,

I spent so much time trying to accomplish this in a portal but I can't get it right. I would like to present an "on-screen" customer account as below: I have a customer file & transaction file and they are related via custid.

Custid: 1234

Customer: ABC Company

Reference.....Debit......Credit.....Balance

---------------------------------------------

C/F......................................50

Invoice1....................100.........150

Invoice2....................200.........350

Pay1............100.....................250

Interest.....................10.........260

Any help would be highly appreciated.

Regards,

Garry

[djmiller]

Garry,

Create a Calculation (unstored) field called Daily Balance with the formula credit-debit. Create another field called Daily Balance Running. This is a summary field = Total of Daily Balance (running). This will give you the required result.

[garrys]

Sorry for my insufficient info... im actually modifying a solution built on FM6. Your solution works well on FM7 above but not on FM6. Any idea how to do it in FM6?