Toggle navigation
Log in
Sign Up
Log in
Sign Up
Appium
C
C#
C++
Docker
Go
Informatica
Java
JavaScript
Kafka
Numpy
Oracle
Pandas
PHP
Py Spark
Python
R
React Native
Scipy
SFTP
Tableau
Teradata
TGMC
UNIX
Introducing
Radical.sh
Forget Code launches a powerful code generator for building API's
Forget_Code.Models.CategoryViewModel
Add a new snippet
Conversion Functions
1
Date Functions
8
Encryption
1
Math Functions
2
Operators
1
String Functions
9
Choose Category
CUME - Find cumulative total in Informatica
Forget Code
Informatica
CUME - Find cumulative total
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] )
Argument
Required/Optional
Description
numeric_value
Required 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_condition
Optional 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
Month
Page Views
Total
Aug
300
300
Sep
400
700
Oct
500
1200
Tags for CUME - Find cumulative total in Informatica
moving sum in infa
moving average in informatica
informatica cume
informatica running sum
running total in informatica
cume function in informatica with filter exam[ple
cume function is available in informatica
how to calculate cumulative sum in informatica
informatica cumulative sum
Contribute to Forget Code, help others.
Add snippet