Spread(Destination,Source,Factor,FactorN,FactorD,Temp,Per)Table 111. Syntax of Spread Function
Parameter | Valid Values |
|---|---|
Destination | A valid destination POV that is a valid combination of Account, ICP and Custom 1-4 members. |
Source | A valid source POV that is a valid combination of dimension members. The Source POV must include a single time period, for example, P#[Year]. The single time period amount is the amount to be spread. |
Factor | A valid source POV. Factor is the account used to store the allocation factor. |
FactorN | A valid source POV. FactorN is the numerator factor used as the basis for spread allocation. |
FactorD | A valid source POV. FactorD is the denominator factor used as the basis for spread allocation. |
Temp | A valid destination Account. Temp is the account that temporarily stores the Source value. |
Per | A period string that defines the name of the first period in the timeframe, for example, "January". The Temp value is stored in the first period and the parameter is required to refer to this in the calculation. |