Hi can any one hlep me i want to displya row total data in first Field TABLE FILE RPT SUM CNT.FIELD BY AVERAGE ACROSS FIELD AS '' ON TABLE ROW-TOTAL AS 'Total_DATA' END I WANT TO DISPLAY TOTALS IN FIRST FIELD LIKE THIS Total_DATA DATA1 DATA2 AVERAGE 2 3 0 3 3 22 4 18 4 42 0 42 5 29 3 26This message has been edited. Last edited by: Kerry,
TABLE FILE RPT SUM CNT.FIELD BY AVERAGE SUM CNT.FIELD BY AVERAGE ACROSS FIELD AS '' ON TABLE ROW-TOTAL AS 'Total' END
- Using AS 8.2.01 on Windows 10 - IE11. | |||
in Focus since 1988 |
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
TABLE FILE CAR SUM COMPUTE TOTCAR/A9 = FPRINT(CNT.CAR, 'I9', 'A9'); BY COUNTRY SUM CNT.CAR BY COUNTRY BY CAR ACROSS SEATS AS '' ON TABLE ROW-TOTAL AS 'Total' ON TABLE SET STYLE * TYPE=DATA, COLUMN=TOTCAR, JUSTIFY=RIGHT ,$ END