Hi,

I have one quite interesting requirement.

There is a SUM. prefix for suming values.

Is there in WebFOCUS prefix or statement that will multiply the values?


Thanks,
Motiejus

If your data is coming in in the correct sort order then a COMPUTE will do the job.

TABLE FILE CAR
SUM SEATS
BY COUNTRY
BY MODEL
ON TABLE HOLD
END
-RUN
TABLE FILE HOLD
SUM
COMPUTE FSEATS/I9= IF COUNTRY NE LAST COUNTRY THEN SEATS ELSE FSEATS * SEATS;
BY COUNTRY
END