Sum - Built-in Database Function¶
Purpose¶
Returns the Sum.
Syntax¶
Sum(type, start, field)
Arguments¶
| Argument | Required | Description |
|---|---|---|
type |
Yes | Summation type |
start |
Yes | Starting point of the summation |
field |
Yes | Field to summarize e.g. {Customer.Purchases} |
Returns¶
Variant with numeric value
Related topics¶
Example¶
// Average Purchases of all customers
Return Sum(drAverage,drReport,{Customer.Purchases})
// Maximum Purchases of customers that are grouped in level 2
Return Sum(drMaximum,drGroup2,{Customer.Purchases})