Calculating a value in the SUBTOTAL
Calculating a value in the SUBTOTAL
(OP)
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?
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
RE: Calculating a value in the SUBTOTAL
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?
RE: Calculating a value in the SUBTOTAL
I'll try it and let you know.
Thanks.
Thanks,
Leo
RE: Calculating a value in the SUBTOTAL
Thanks,
Leo
RE: Calculating a value in the SUBTOTAL
Thanks,
Leo
RE: Calculating a value in the SUBTOTAL