Problem with subtotals of 1 to many table relationship 1

[MrBillSC]

Crystal ver 8.5
My report uses 3 tables:
Table A contains G/L account numbers.
Table B contains Budget info for each account number.
Table C contains transactions (adjustments, expenditures, etc.) for each account number.

Table A has a 1 to 1 relationship with table B (equal join).
Table B has a 1 to many relationship with table C (left outer join).

I am grouping the report at 3 levels of the G/L account number:
1. Fund
2. Department
3. Division
I want subtotals at each level for all of the table C records and the Budget amount subtotal from the table B record.

The problem is that if table C has more than one record, my budget subtotals (from table B) double, triple, etc.
I have tried creating formulas to set the budget amount only one time for each G/L account number, but I end up using some sort of summary function to do it and cannot use subtotals with the formula field.

There must be a simple solution that I am not seeing.
Any ideas?

 

[jadzian]

You are right, where is simple solution. I suggest use Running Total Field. This is one of basic field that you can find in menu Inser->Fields.