Returns the computed sum of the values in a list.
Sample usage
SUM(Classes[Seat Count])
returns the sum of all values in the Seat Count
column of the Classes
table. Equivalent to SUM(SELECT(Classes[Seat Count], TRUE))
. See also: SELECT()
SUM([Discounts])
returns the sum of the items in the Discounts
column value, where Discounts
is of type List
or EnumList
.
SUM(LIST(1, 2, 3))
returns Number
: 6
Sum values from select rows
Compute the total delivery charges recorded within a reporting period:
SUM(
SELECT(
Deliveries[DeliveryCharge],
AND(
([DateDone] >= [_THISROW].[BeginDate]),
([DateDone] < [_THISROW].[EndDate])
)
)
)
SELECT(Deliveries[DeliveryCharge], ...)
gets a list of delivery charges from select rows in theDeliveries
table.AND(..., ...)
limits theSELECT()
results to only those rows that match all of the conditions.([DateDone] >= [_THISROW].[BeginDate])
limits the count to only rows with aDateDone
no earlier than the report'sBeginDate
.([DateDone] < [_THISROW].[EndDate])
further limits the rows to those with dates before the report's end date.SUM(...)
totals the values from the result of theSELECT()
.
Common Problems
SUM(1, 2, 3)
: the arguments are not in list form. To fix, wrap them in LIST()
to construct a list: SUM(LIST(1, 2, 3))
.
Syntax
SUM(list)
list
- List of any numeric type.
Notes
AppSheet must be given enough context to determine what type of values list
contains, that its contents are or will be numeric. To that end, list
must be one of the following: a column value of type List
that contains numeric values; a column list (such as, Products[Price]
) for a column of a numeric type; or a constructed list (such as, with LIST()
) of a numeric type.