Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

ACUMULADO

On this page (10)

Running sum up to the current point on the axis.

FieldValue
CategoryContext and filter
TypeAggregation (operates on a set of rows)
Arity1 argument (fixed)
Compiles to SQL (calculated column)No
VersionFormula engine v3.

Aliases#

Canonical name: ACUMULADO. Accepted aliases (case-insensitive): running.

Syntax#

code
ACUMULADO(coluna)

The 1st argument is the name of a column (bare identifier); the others are expressions.

Returns#

Number (running sum up to the point on the axis).

Null handling#

Only rows with a value go into the running total.

Evaluation context#

Uses the rows up to the current group in axis order (runningRows).

Differences from DAX#

  • DAX equivalent: —
  • Compatibility: No direct DAX equivalent
  • Note: There is no single DAX function; it is equivalent to the running total pattern CALCULATE(measure; FILTER(ALL(axis); axis <= MAX(axis))).

Examples#

code
ACUMULADO(receita)

Example with values#

Input: run RJ(40) → SP(60), at point SP.

code
ACUMULADO(receita)  →  100

Expected result: 100

Business example#

Running total (accumulated revenue) along the chart axis.

Common errors#

Typos in a column name, an incompatible type, or an invalid argument become a friendly message (pt-BR) — the engine never silently returns a wrong number.


← Back to the formula index

Related links