Calculating a value in the SUBTOTAL

DEFINE FILE CAR
SUBA/I6 = 55;
SUBB/I6 = 75;
END

TABLE FILE CAR
PRINT SUBA
SUBB
COMPUTE PCT/D6.2 = ((SUBB - SUBA)/SUBB) * 100;
BY COUNTRY
ON COUNTRY RECOMPUTE
ON COUNTRY SUB-TOTAL
IF RECORDLIMIT EQ 5
END

Returns

PAGE 1

COUNTRY SUBA SUBB PCT

ENGLAND 55 75 26.67
*TOTAL ENGLAND 55 75 26.67
FRANCE 55 75 26.67
*TOTAL FRANCE 55 75 26.67
ITALY 55 75 26.67
*TOTAL ITALY 55 75 26.67
JAPAN 55 75 26.67
*TOTAL JAPAN 55 75 26.67
W GERMANY 55 75 26.67
*TOTAL W GERMANY 55 75 26.67
*TOTAL W GERMANY 55 75 26.67
TOTAL 275 375 26.67

Is that what you were looking to do?

It appears like what i am trying to do, but I will have many detail records before the subtotals.

I'll try it and let you know.
Thanks.


Thanks,

Leo ;-)

In other words, the PCT field should be calculated from the SUBTOTALS; not the detail records.


Thanks,

Leo ;-)

The above code calculated the values for each row, but it's showing the total of the PCT column instead of showing the computed field as the PCT subtotal.


Thanks,

Leo ;-)

On the SUBTOTAL line ('ON field ...') do you say SUBTOTAL or SUB-TOTAL, which adds up the COMPUTEd field, or RECOMPUTE/SUMMARIZE, which redoes the calculation, based on subtotaled values?