Calculating a value in the SUBTOTAL

[LeonelSanchezJr]

I have a report which requires SUBTOTALS.

The problem starts with the third column which is calculated based off of the 1st and 2nd SUBTOTALS.

Example:

SUBTOTAL_A SUBTOTAL_B CALCULATED_VALUE
55 75 26.66%


Formula is:
((SUBTOTAL_B - SUBTOTAL_A)/SUBTOTAL_B) * 100


Can this be done in the Subtotal area?


Thanks,

Leo ;-)

 

[mmiles]

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?

 

[LeonelSanchezJr]

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 ;-)

 

[LeonelSanchezJr]

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


Thanks,

Leo ;-)

 

[LeonelSanchezJr]

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 ;-)

 

[focwizard]

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?