SPREAD(Value to divide, Number of time periods)
|Value to divide||Number||The value to be spread across the time periods.|
|Number of time periods||Number||The number of time periods to spread the value over.|
The SPREAD function returns numeric values.
- You cannot have a decimal value for the number of time periods.
- The time range for the values to be spread and the line item that contains your result, must match. Any formula that conflicts with this rule will be rejected.
- A non-time series function, if used as a subexpression 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 differing time range can return an unexpected result or an error message. For more information, see Time Ranges and Time Series Functions.
Related Anaplan functions
|Jan 19||Feb 19||Mar 19||Apr 19||May 19||Jun 19|
|Value to spread||10 000||0||4000||0||0||0|
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, as long as the Summary Method for the row is set to SUM.