SUM(Classes[Seat Count]) : The sum of all values in the Seat Count column of the Classes table. Equivalent to
SUM(SELECT(Classes[Seat Count], TRUE)). See also
SUM([Discounts]) : The sum of the items in the
Discounts column value, where
Discounts is of type List or EnumList.
SUM(LIST(1, 2, 3)) returns
Sum Values from Select Rows
Compute the total delivery charges recorded within a reporting period:
([DateDone] >= [_THISROW].[BeginDate]),
([DateDone] < [_THISROW].[EndDate])
SELECT(Deliveries[DeliveryCharge], ...)gets a list of delivery charges from select rows in the
AND(..., ...)limits the
SELECT()results to only those rows that match all of the conditions.
([DateDone] >= [_THISROW].[BeginDate])limits the count to only rows with a
DateDoneno earlier than the report's
([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 the
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)).
SUM( some-list )
some-list(list of any numeric type)
AppSheet must be given enough context to determine what type of values
some-list contains, that its contents are or will be numeric. To that end,
some-list must be one of the following: a column value of type
List that contains numeric values; a column list (e.g.,
Products[Price]) for a column of a numeric type; or a constructed list (e.g., with
LIST()) of a numeric type.
The computed sum of the values in