Data connectivity & integrationPipeline Builder ExpressionsSum

Sum

Supported in: Batch, Streaming

Sums the specified expression.

Expression categories: Numeric

Declared arguments

  • Expression - The column to be summed.
    Expression<Numeric>

Output type: Decimal | Double | Long

Examples

Example 1: Base case

Argument values:

  • Expression: values

Given input table:

values
2
4
3

Outputs: 9


Example 2: Null case

Argument values:

  • Expression: values

Given input table:

values
2
null
3

Outputs: 5