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