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.