Running sum up to the current point on the axis.
| Field | Value |
|---|---|
| Category | Context and filter |
| Type | Aggregation (operates on a set of rows) |
| Arity | 1 argument (fixed) |
| Compiles to SQL (calculated column) | No |
| Version | Formula 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) → 100Expected 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.