All eazyBI for Jira eazyBI for Confluence Private eazyBI

CumulativeSum

EAZYBI Calculates the sum of visible row values cumulatively.
This function uses report visible members only and will not return expected results when drilling into details . We recommend disabling drill actions with special annotations comments.

Syntax

CumulativeSum(Numeric_expression)

Arguments

Numeric_expression

MDX expression that returns a number

Examples

The following formula will count created issues for rows cumulatively.

-- annotations.disable_drill=true
CumulativeSum([Measures].[Issues created])

The following formula calculates the % of resolved issues cumulatively. 

-- annotations.disable_drill=true
CumulativeSum([Measures].[Issues resolved %])

See report example Lead time distribution in our demo account. The measure Cumulative issues resolved % uses this formula added via default calculations: Add calculated > cumulative sum > including empty for measure Issues resolved %

See also