Focal Point
Subtotals with MAX.

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2971087331

July 02, 2004, 03:51 PM
reFOCUSing
Subtotals with MAX.
What I'm trying to do is create a subtotal row but I'm using MAX. in the table call and the subtotal row is adding up all the values in that field. What I want to see is just the MAX of that field in the subtotal.

I have tried RECAP but this does not work since it makes the report too long. I was also thinking of appending a table to the report that has the summaried results but there has to be a better way then doing this. Any ideas or help would be great.

Here is a sample of what I'm doing:

TABLE FILE table1
SUM
field1
MAX.field2

COMPUTE field3/D7.2 = field1 * MAX.field2;

BY field4
BY field5

END
July 02, 2004, 05:51 PM
<WFUser>
I don't know why RECAP would make the report any bigger. This should work.

TABLE FILE CAR
SUM MAX.DCOST NOPRINT
BY COUNTRY
SUM RCOST MAX.DCOST
COMPUTE DIFF/D8 = RCOST - MAX.DCOST;
BY COUNTRY
ON COUNTRY RECAP MAXD/D6 = C1;NOPRINT
ON COUNTRY SUBFOOT
""
BY CAR
END
July 05, 2004, 10:05 PM
GCohen
WFUSER's reply is correct except the easiest
way to display the value.. is ..
ON COUNTRY RECAP MAXD=C1 ;
ON COUNTRY SUBFOOT
" MAX IS
The RECAP when displayed in a SUBFOOT automatically supresses itsdefault display.