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 20Tableau
~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!~;
tSQL
~SUM!~(‹measure›)
Python
~sum!~(‹number_array›)
Last updated
Was this helpful?