Focal Point
ROW TOTAL LINE BY LINE

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8061055482

May 18, 2008, 03:53 AM
Cati - France
ROW TOTAL LINE BY LINE
Hello,

Here is my code
...
TABLE FILE SQLOUT
SUM
FUNBPP WITHIN FUDPTT AS 'Poste'
FUNBPS/D6 AS 'Safig'
COMPUTE DIFF1/D6 = FUNBPP - FUNBPS; AS 'Poste-Safig'
FUNBTP AS 'Poste'
FUNBTS AS 'Safig'
COMPUTE DIFF2/D7 = FUNBTP - FUNBTS; AS 'Poste-Safig'
COMPUTE TOTP/D8 = FUNBPP + FUNBTP; AS 'Poste'
COMPUTE TOTS/D8 = FUNBPS + FUNBTS; AS 'Safig'
COMPUTE DIFFT/D8 = TOTP - TOTS; AS 'Poste-Safig'
BY FUDPTT AS 'Date'
ON TABLE NOTOTAL

I want to have a colum total for each line witch is the value of FUNBPP + previous total
Example :
First line : FUNBPP = 5, Total = 5
Second line : FUNBPP = 10, Total = 15
Third line : FUNBPP = 8, Total = 23....

How can I code that ?
Thanks for help


7.7.02 (Html, Excel, Ahtml, Pdf,Graph,.....)
OS400 V5R3, V5R4
Windows 2000/2003/2007/2010
May 18, 2008, 04:07 AM
Alan B
Cati

Try using the LAST function.

COMPUTE RUN_TOT/D6 = LAST RUN_TOT + FUNBPP;


Alan.
WF 7.705/8.007
May 18, 2008, 04:17 AM
Cati - France
quote:
COMPUTE RUN_TOT/D6 = LAST RUN_TOT + FUNBPP;


Super !
Thank you very much Alan
Catherine


7.7.02 (Html, Excel, Ahtml, Pdf,Graph,.....)
OS400 V5R3, V5R4
Windows 2000/2003/2007/2010