Finds the sum of a column for all adjacent periods in normalized rows whose Period values either meet or overlap.
Syntax
[TD_SYSFNLIB.] TD_SEQUENCED_SUM ( 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
-
Any expression that evaluates to a Period data type.
The Period expression must be comparable with the other expression. Implicit casting to a Period data type is not supported.
- TD_SYSFNLIB.
- Name of the database where the function is located.