MarkLogic 9 Product Documentation

cts:sum-aggregate

cts:sum-aggregate(
   $range-index as cts:reference,
   [$options as xs:string*],
   [$query as cts:query?],
   [$forest-ids as xs:unsignedLong*]
) as xs:anyAtomicType?

Summary

Returns the sum of the values given a value lexicon. This function works like cts:sum except it performs the calculation in parallel in all data nodes then aggregates the values. It generally performs better than cts:sum, especially on large clusters.

Example

xquery version "1.0-ml";

  (:
     This query assumes an element range index is configured
     in the database for the 'Amount' element.
  :)

cts:sum-aggregate(cts:element-reference(xs:QName("Amount")))

=> 733.7600000000000128