1. Calculation functions
  2. All functions
  3. Time and date functions
  4. SPREAD

The SPREAD function divides a value evenly over a number of time periods. 

Syntax

SPREAD(Value to divide, Number of time periods)

Arguments

ArgumentData typeDescription
Value to divideNumberThe value to be spread across the time periods.
Number of time periodsNumberThe number of time periods to spread the value over. 

The SPREAD function returns numeric values. 

Constraints

  • You cannot have a decimal value for the number of time periods.
  • The Value to divide and Number of time periods arguments must have the same Time range.

Excel equivalent 

SLN

Related Anaplan functions

Examples


Jan 19Feb 19Mar 19Apr 19May 19Jun 19
Value to spread10 00004000000

Spread

SPREAD(Value to spread, 4)

250025003500350010001000

From the example above, the value 10000 is entered into the Value to spread cell for Jan 19 and is spread over the next 4 months.

When an additional value of 4000 is added in Mar 19, the value is also spread over the next 4 months. The overlapping months are summed to provide a final figure.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.