May 18, 2008, 03:53 AM
Cati - FranceROW 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
May 18, 2008, 04:07 AM
Alan BCati
Try using the LAST function.
COMPUTE RUN_TOT/D6 = LAST RUN_TOT + FUNBPP;
May 18, 2008, 04:17 AM
Cati - Francequote:
COMPUTE RUN_TOT/D6 = LAST RUN_TOT + FUNBPP;
Super !
Thank you very much Alan
Catherine