Finds the sum of a column for all the rows that were normalized because their Period values overlap.
Syntax
[TD_SYSFNLIB.] TD_SUM_NORMALIZE_OVERLAP ( grouping_column_list, numeric_column, period_column )
- grouping_column_list
- One or more grouping columns, not including the Period column. You must specify the input as a dynamic UDT.
- numeric_column
- A numeric column on which SUM() is requested. You must specify the input as a dynamic UDT.
- period_column
-
An expression that results in a DATE, TIMESTAMP, or TIMESTAMP WITH TIME ZONE value.
A column with a data type of PERIOD(DATE), PERIOD(TIMESTAMP), or PERIOD(TIMESTAMP WITH TIME ZONE).
- TD_SYSFNLIB.
- Name of the database where the function is located.