Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

CUME - Find cumulative total in Informatica

CUME function is used to find running total. Similar to Moving Sum and Moving AVG.

CUME funciton adds the current row value to previous total and makes it as new total.
Syntax
CUME( numeric_value [, filter_condition] )

ArgumentRequired/OptionalDescription
numeric_valueRequired Numeric datatype. Passes the values for which you want to calculate a running total. You can enter any valid transformation expression. You can create a nested expression to calculate a running total based on the results of the function as long as the result is a numeric value.
filter_conditionOptional Limits the rows in the search. The filter condition must be a numeric value or evaluate to TRUE, FALSE, or NULL. You can enter any valid transformation
expression.

When a row has null value, CUME retains previous total. If all the rows have NULL value, CUME returns NULL for all rows.
Example : Find history of page views provided monthly page views
MonthPage ViewsTotal
Aug300300
Sep400700
Oct5001200