Running Total not working....

[MrCedars]

I have the following Fields that I am trying to get a running total from, when I do it gives me a number but it is wrong.

DH_TRANS_DATE -> DATE

DH_CODE -> Transaction Type (NUMBER)

SumOfDH_TOTAL -> Transaction Total (NUMBER)

CODES_DH_TOTAL -> CALCULATION (10)(No of Rep)

Case(Get(CalculationRepetitionNumber)=(Extend(FM_CODE));

Extend(SumOfDH_TOTAL))

CODES_TOTALS -> SUMMARY (10)(No of Rep)

=Total of CODES_DH_TOTAL

CODES_TOTALS_BY_DATE -> CALCULATION (10)(No of Rep)

GetSummary(CODES_TOTALS; DH_TRANS_DATE)

CASH_BOOK -> CALCULATION

-(GetRepetition(CODES_TOTALS_BY_DATE;3)-GetRepetition(CODES_TOTALS_BY_DATE;8)-GetRepetition(CODES_TOTALS_BY_DATE;9))

CASH_BOOK_SUM -> SUMMARY

Total of CASH_BOOK (running)

The layout items are placed in "Sub-summary when sorted by: DH_TRANS_DATE" all figures come out correctly including the CASH_BOOK value for each date but if I introduce the CASH_BOOK_SUM the running total it does not give me the correct figure. So lets say the one day there was 100 in transaction and 100 the next it should be 200 and so on, but it gives me some outrageous number like 2500.

Any help would be appreciated.

Thanks

Edited July 6, 2007 by Guest