1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. DECUMULATE

Calculates the difference in a value between the current period and the previous period.

Syntax

DECUMULATE(x)

where:

  • x: Line item to compare

Format

Input Format Output Format

x: Number

Number

Arguments

The function uses the following arguments:

  • x: Number: Numeric line item, property, or expression

Constraints

The function has the following constraints:

  • The time range providing arguments to a line item must match the time range for the result line item. Any formula that conflicts with this rule will be rejected. For more, see Search.
  • A non-time series function, used as a sub-expression of this function, must use the same time range as the line item to which the formula is applied. Combining time series functions and non-time series functions with a time range could return an unexpected result or an error message. For more, see Time Ranges and Time Series Functions.

Excel equivalent

  • No Excel equivalent

Back to Top

Example

Use a module with columns formatted to use Time, and rows formatted as line items, with the line item Operating Profit showing the total profit per period. A line Item Change per Period with the formula

Decumulate(Operating Profit) 

shows the change from the previous period.

Back to Top

Similar functions