Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recompute and AVE Column

Status
Not open for further replies.

LeonelSanchezJr

Programmer
Jan 26, 2001
522
US
I am using DEV Studio 7.6.7
I have the following code:
TABLE FILE HOLD1
SUM
AVE.AVGS NOPRINT
BY BOX
SUM
AVE.EXT_AMT
BY BOX
ACROSS SLD2_NAME
COMPUTE TEST/D12.2 = AVE.AVGS; AS AVGS
ON TABLE RECOMPUTE AVE. EXT_AMT AVE. AVGS AS 'Total-Average'
END
-*
Everything works great except for my "total line"
It RECOMPUTES the EXT_AMT, however, it SUMS my TEST field.
I need the TEST field to be recomputed for an AVERAGE of that column.



Thanks,

Leo ;-)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top