total method
Calculate the sum of all non-null values in the group.
If all values in the group are null, total returns 0.0
. This function
uses floating-point values internally.
To only consider rows matching a predicate, you can set the optional
filter
. Note that filter
is only available from sqlite 3.30, released on
2019-10-04. Most devices will use an older sqlite version.
Implementation
Expression<double?> total({Expression<bool?>? filter}) =>
_AggregateExpression('TOTAL', [this], filter: filter);