Sum

Sum( arrayOrSet )
Sum( arrayOrSet )
Sum( arrayOrSet )
Sum( arrayOrSet )
sum( arrayOrSet )
Sum( arrayOrSet )

The run time of Sum is dependent on the number of elements in the underlying set or page (it’s linear, or O(1)). For very large sets or pages, executing Sum might result in a query timeout error.

To work around this, you may specify a larger query timeout via the driver that you are using.

Description

The Sum function returns the sum of all items in arrayOrSet, which is an Array, Page, or Set.

Parameters

Argument Type Definition and Requirements

arrayOrSet

Array, Page, or Set

The array, page, or set that should have its items summed.

Returns

A Number representing the sum of all items in arrayOrSet.

Examples

The following query returns the sum of items in the provided array:

Value result = await client.Query(
  Sum(Arr(1, 2, 3, 4, 5, 6, 7, 8, 9, 10))
);

IResult<Value> data = result.To<Value>();
data.Match(
  Success: value => Console.WriteLine($"{value}"),
  Failure: error => Console.WriteLine($"Query failed:\n{error}")
);
LongV(55)
result, err := client.Query(
  f.Sum(f.Arr{1, 2, 3, 4, 5, 6, 7, 8, 9, 10}))

if (err != nil) {
  fmt.Println(err)
} else {
  fmt.Println(result)
}
55
System.out.println(
    client.query(
        Sum(
            Arr(
                Value(1), Value(2), Value(3), Value(4), Value(5),
                Value(6), Value(7), Value(8), Value(9), Value(10)
            )
        )
    ).get()
);
55
client.query(
  q.Sum([1, 2, 3, 4, 5, 6, 7, 8, 9, 10])
)
.then((ret) => console.log(ret))
55
print(client.query(
  q.sum([1, 2, 3, 4, 5, 6, 7, 8, 9, 10])
))
55
println(Await.result(
  client.query(
    Sum(Arr(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)),
  ),
  5.seconds)
)
55

Is this article helpful? 

Tell Fauna how the article can be improved:
 Visit Fauna's forums or email docs@fauna.com

Thank you for your feedback!