I was very surprised to discover that a PCT Prefix Operator does not work on a COMPUTEd field, the value in the PCT field is the same as the computed field.

JOIN CLEAR *
JOIN PCD IN GGSALES TO PCD IN GGPRODS AS J1
-RUN

TABLE FILE GGSALES
SUM
COMPUTE SALES_AMT/D12 = UNITS * UNIT_PRICE;
PCT.SALES_AMT/D20.4 AS 'SALES_PCT'
BY PRODUCT
END
-RUN

Same in 7.6.2 Francis.

Sean

Sean,

Thanks for testing this. I couldn't find anything in the documentation that suggests this should not work.

Cheers,

Francis,

This makes sense. Obviously other prefix operators such as MIN, MAX, FST and LST would not work on a COMPUTE when SUMming because WF no longer knows the original detail records when it goes back to process the internal matrix.

I would guess that PCT does not work either because COMPUTEs are calcualted on a row by row basis and therefore WF does not know the TOTAL until it gets to the last record in the report. At that point it will not go back and process the records in the internal matrix again.

Mickey,

Your argument makes sense.

Cheers,

Would this work?

JOIN CLEAR * JOIN PCD IN GGSALES TO PCD IN GGPRODS AS J1 
-RUN 
DEFINE FILE GGSALES
DUMMY/A1='';
END
TABLE FILE GGSALES
 SUM 
COMPUTE SALES_AMT1/D12 = UNITS * UNIT_PRICE; NOPRINT
BY DUMMY NOPRINT
 SUM 
COMPUTE SALES_AMT2/D12 = UNITS * UNIT_PRICE; 
COMPUTE PCTSA/D7.2=SALES_AMT2/SALES_AMT1;
BY DUMMY 
BY PRODUCT 
END 
-RUN

just a thought..