The SPREAD function divides a value evenly over multiple entities. 

SPREAD(Value to divide, Entity count [, List])

ArgumentData typeDescription
Value to divideNumberThe value to be spread across the entity count.
Entity countNumberThe number of entities over which to spread the value. 
List (Polaris-only)List

The list over which the function should operate.

See Calculation engine functionality differences.

The SPREAD function returns a number. 

  • In Polaris, you can't use the SPREAD function for line items that have the Formula summary method. In the Classic Engine, you can.
  • In Polaris, you can use the SPREAD function over any dimension, by including an additional argument. In the Classic Engine, you can't. Where, if the additional argument isn't included, the function defaults to Time as the dimension.

If you are operating over time, the Value to divide and Entity count arguments must have the same time range.

SLN


Jan 19Feb 19Mar 19Apr 19May 19Jun 19
Value to spread10000400000
SPREAD(Value to spread, 4)250250350350100100

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

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