Hi All Expert,
I have one requirement which will need to bring down the balance forward value in grouping level.
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.