Sum
In most cases, this will be the total within a field of numerical data, though you might also want to sum a filtered subset of numbers or a list of numbers provided by you, e.g. as an array [2,7,8,3]. All the sum functions below will allow you to choose either a set of numerical values or specify your own.
Excel
=~SUM!~(‹number_array›) =~SUM!~(‹number1›«, number2», «numberN»)
=SUM(A:A)
// OR
=SUM(2,7,8,3) // Returns 20
Tableau
~SUM!~(‹measure›)
SUM([Sales])
Alteryx
Use the Summarize tool (in the Transform palette):
(group by field, sum by measure).
OrgVue
‹measure›.~sum!~; ‹number_array›.~sum!~;
nodes().sales.sum
// OR
array(2,7,8,3).sum // Returns 20
tSQL
~SUM!~(‹measure›)
SELECT SUM(sales)
FROM SalesData
Python
~sum!~(‹number_array›)
sum([2,7,8,3]) # Returns 20
Last updated
Was this helpful?