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
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.