All eazyBI for Jira eazyBI for Confluence Private eazyBI


Returns the sum of a numeric expression evaluated over a set.

If a numeric expression is specified, the specified numeric expression is calculated for each set member and then sum of all these results is returned. If a numeric expression is not specified, the specified set is evaluated in the current context of the members of the set and then summed.

Before you create the calculated measure with the average function, check if you can use standard functionality to add statistical calculations.


Sum(Set_Expression, Numeric_Expression)



MDX expression that returns a set for which the sum will be found.


MDX expression that returns a number that will be summed up across the set.


The following example calculates the cumulative amount of resolved issues over time.

  -- set of previous time periods until selected time period
  -- numeric expression
  [Measures].[Issues resolved]

See also