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

Spreads a value evenly over a number of whole periods.

This function is useful for calculating straight-line depreciation.

Syntax

SPREAD(x,n)

where:

  • x: Number - value to divide
  • n: Number - number of periods

Format

Input Format Output Format

x: Number

n: Number: Decimal converted to integer

Number

Arguments

The function uses the following arguments:

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

Constraints

The function has the following constraints:

  • This function divides a value over whole periods, so does not accept a decimal value for the number of periods.
  • 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 information, 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 information, see Time Ranges and Time Series Functions.

Excel equivalent

Back to Top

Example

A module is configured to show Time in Columns with a Month time scale, with line items as Rows. Line items are Value to Spread and Spread.

The formula

SPREAD(Value to spread, 4)        

is added to the Spread line item.

When a value 10000 is entered into the Value to Spread cell for January, the value is spread over the next 4 months.

If an additional value 4000 is added in March, that value is also spread over the next 4 months; the overlapping months are summed to provide a final figure (as long as the Summary Method for the row is set to SUM).

Back to Top

Similar functions