Balance forward in Crystal Report

Hi All Expert,

I have one requirement which will need to bring down the balance forward value in grouping level.

Example:

I have a report design which will group be Date and have three summary total fields (Balance Forward, Current Total, Total Amount)

Date Balance Forward Current Total Total Amount

1 Jan 100 100 200

2 Jan 200 300 500

3 Jan 500 100 600

I wish to bring down the total amount from one date to another date on the date grouping level. I tried to use the previous function in Crystal Report formula but it was unable to sum it out.

Appreciated your kind advice how can do this in Crystal Report.

TQ.

Regards,

CK