Calculates the difference in a value between the current period and the previous period.
- x: Line item to compare
|Input Format||Output Format|
The function uses the following arguments:
- x: Number: Numeric line item, property, or expression
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.
- No Excel equivalent
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
shows the change from the previous period.