SUM
The SUM function returns a sum of all numbers in the set (e.g., Salary Paid).
Syntax
SELECT SUM(…)
SELECT SUM(fact)
Examples
The metric defined by the SUM of the Sales fact would be computed by adding revenue earned from all individual sales transactions:
SELECT SUM({fact/sales})