Skip to main content

cumulative Sum or moving sum in Informatica




CUME (PERSONAL_SALES)

 PERSONAL_SALES      RETURN VALUE
40000                40000
80000                120000
40000                160000
60000                220000

MOVINGSUM (SALES,2)

ROW_NO              SALES      RETURN VALUE
1                600               NULL
2                504               1104 (600+504)
3                36                 540 (504+36)
4                100               136 (36+100)
5                550               650 (100+550)
6                39                 589 (550+39)
7                490               529 (39+490)

Comments