See the following:

TABLE FILE CAR
SUM
     DEALER_COST
     RETAIL_COST
     SALES
     COMPUTE GAP/D7 = RETAIL_COST - DEALER_COST;
     COMPUTE RATIO/D4.2L = GAP / SALES;
BY  LOWEST COUNTRY 
BY  LOWEST CAR
ON COUNTRY RECOMPUTE
     CNT. SALES
     GAP
     RATIO MULTILINES AS '*TOTAL'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
END

In WF8007 you will notice that on the total line RATIO is ****.
This does not occur in 8002.
If you change the format of GAP to D12.2, you will see that RATIO is recomputed using CNT. SALES and not SALES.

This message has been edited. Last edited by: Danny-SRL,

... and if you remove the space between CNT. and SALES? Does not that give the correct value?

TABLE FILE CAR
SUM
     DEALER_COST
     RETAIL_COST
     SALES
     COMPUTE GAP/D7 = RETAIL_COST - DEALER_COST;
     COMPUTE RATIO/D4.2L = GAP / SALES;
BY  LOWEST COUNTRY 
BY  LOWEST CAR
ON COUNTRY RECOMPUTE
     CNT.SALES
     GAP
     RATIO MULTILINES AS '*TOTAL'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
END

T

Tony,
Sorry about the delay.
Your solution is correct.
However, the space was produced by the GUI and it is the correct syntax by the book (see pages 322 and following in wf77crlang.pdf).
So...

quote:

the space was produced by the GUI

Hi Danny,

So, you're using the GUI these days .......

It comes to us all eventually ....


T

Hi Tony,
In moments of curiosity...