Thank you, bless you but what do I put in the var's? Sure they need to refer to the group total field but how do I refer to a field that hasn't a name but is the sum() of a group column.
>Simple. You really need two report variables for this.
>
>>Please consider the sample rpt layout below.
>>
>>The Route totals are at a group footing, totalling when group Route changes. So the values (in the 1st 2 totals: 370 and 400) are calculated, via Report Expression dialog, by the total fields being the same as the cursor fields: Trip1 and Trip2 (i.e their columns) and, via teh "Calculations" button -> Calculate Field dialog and "Sum" radio button selected.
>>
>>Trouble is, I need to do some maths on the 2 total fields, working out the percentage difference between them (in this example - 8%).
>>
>>
So how do I refer to the calculated totals fields, in the %age field in order to produce its equation?>>
>>I suppose there may be a similar problem in getting the tot of tots, e.g. Operator and Scheme totals but I haven't come to them yet.
>>
>>'ppreciate it
>>
>>Terry
>>
>>
>>Operator Route Class No. No.
>> Passengers Passengers Multiplier Multiplier Trips Trips
>>A 21 14 120 1 120 0
>> 15 100 2.5 250 0
>> 40 400 1 0 400
>> Route total 370 400 8%
>>
>> 22 14 300 1 300 0
>> 40 350 1 0 350
>> Route total 300 350 17%
>> Operator total 670 750 12%
>>B 1 - details ... - 880 1150 31%
>>
>> 2 120 50 -58%
>> Operator total 1000 1200 20%
>> Scheme total 1670 1950 17%
>>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.