Cumulative $ [Solved]

June 17, 2011, 08:50 AM

Shubha Manjit

-DEFAULT &FROMDT ='2010/03/14'
-DEFAULT &TODT ='2010/03/26'

TABLE FILE AAA
SUM COSTAMT
BY COSTDT
WHERE COSTDT GE '&FROMDT' AND COSTDT LE '&TODT';
END

OUTPUT of the above code:
COSTDT COSTAMT
2010/03/18 1424.6900
2010/03/22 31293.2500
2010/03/23 8429.5600
2010/03/24 8653.3200
2010/03/25 11015.5500

In this code I am summing the COSTAMT for each date. Instead I want the COSTAMT field to be cumulative sum, which means 2010/03/18 will have 1424.6900, next 2010/03/22 should be '31293.2500 + 1424.6900' (COSTAMT for 2010/03/22 + COSTAMT for 2010/03/18). So my final output should look like this :

COSTDT COSTAMT
2010/03/18 1424.6900
2010/03/22 32717.9400
2010/03/23 41147.5000
2010/03/24 49800.8200
2010/03/25 60816.3700

How do I do this? Help in the form of code would very useful.

This message has been edited. Last edited by: Shubha Manjit,

June 17, 2011, 10:09 AM

<FreSte>

Help is already available in this forum, see here (Running Total)

but for your example it would be something like this:

FILEDEF CDATA DISK CDATA.MAS
-RUN
-WRITE CDATA FILENAME=CDATA, SUFFIX=FIX, $
-WRITE CDATA SEGNAME=CDATA, SEGTYPE=S1, $
-WRITE CDATA   FIELD=COSTDT,       ALIAS=E01,    FORMAT=YYMD   ,$
-WRITE CDATA   FIELD=COSTAMT,      ALIAS=E02,    FORMAT=D12.4   ,$

FILEDEF CDATA DISK CDATA.FTM
-RUN
-WRITE CDATA 20100322  31293.2500
-WRITE CDATA 20100323   8429.5600
-WRITE CDATA 20100318   1424.6900
-WRITE CDATA 20100324   8653.3200
-WRITE CDATA 20100325  11015.5500

TABLE FILE CDATA
  SUM
    COMPUTE RUNNING_TOTAL/D12.4 = LAST RUNNING_TOTAL + COSTAMT;
  BY COSTDT
END