clevelandjwb
Programmer
Below is an output table.
Staff_Status Data 2002 2003 2004
F Sum of Tot_Miles 87,686 113,481 131,360
Sum of Bus_Miles 73,068 92,576 107,969
Sum of Lease_Value $2,442 $2,462 $2,673
Sum of Pers_Value $3,246 $3,612 $3,960
S Sum of Tot_Miles 300,177 290,641 285,710
Sum of Bus_Miles 111,127 103,597 94,488
Sum of Lease_Value $29,266 $26,314 $27,209
Sum of Pers_Value $39,664 $36,601 $37,726
Total Sum of Tot_Miles 387,863 404,122 417,070
Total Sum of Bus_Miles 184,195 196,173 202,457
Total Sum of Lease_Value $31,708 $28,776 $29,882
Total Sum of Pers_Value $42,910 $40,213 $41,686
I would like to display the percentage of Bus_Miles with respect to Tot_Miles. For example in "F" of "2002" that would be 73068/87686 or 83%. I have fiddled with "% of" but am having trouble making anything work. I select Tot_Miles for the Base field but am at a loss as to what Base item should be. It looks like I am making a calculation on the detail items rather than the sums.
Thanks for any help.
John
Staff_Status Data 2002 2003 2004
F Sum of Tot_Miles 87,686 113,481 131,360
Sum of Bus_Miles 73,068 92,576 107,969
Sum of Lease_Value $2,442 $2,462 $2,673
Sum of Pers_Value $3,246 $3,612 $3,960
S Sum of Tot_Miles 300,177 290,641 285,710
Sum of Bus_Miles 111,127 103,597 94,488
Sum of Lease_Value $29,266 $26,314 $27,209
Sum of Pers_Value $39,664 $36,601 $37,726
Total Sum of Tot_Miles 387,863 404,122 417,070
Total Sum of Bus_Miles 184,195 196,173 202,457
Total Sum of Lease_Value $31,708 $28,776 $29,882
Total Sum of Pers_Value $42,910 $40,213 $41,686
I would like to display the percentage of Bus_Miles with respect to Tot_Miles. For example in "F" of "2002" that would be 73068/87686 or 83%. I have fiddled with "% of" but am having trouble making anything work. I select Tot_Miles for the Base field but am at a loss as to what Base item should be. It looks like I am making a calculation on the detail items rather than the sums.
Thanks for any help.
John