Sum

This Flow Script tutorial explains how to use the Sum function with syntax and examples.

Description‌

The Sum function returns the summarized value of the specified table column.

Syntax

‌The syntax for the Sum function is:

Sum(table.column)

‌Parameters

table.column - the table column which is to be summarized.

Returns

‌The Sum function returns a number.

Example‌

Let's look at some Sum function examples and explore how to use the Sum function.‌

Example table: orderQuantity

sum(orderQuantity.Quantity)
Result: 27

Sum([col: "4"] & [col: "7"])
Result: 11

let projectedProfit = sum((orders where isConfirmed).value) - sum(expenses.cost);