Embedded Files
Description
Description
RangeToDAλ() converts a static range into a dynamic range. This is useful when we need to convert actuals to an array that spans actuals and forecast periods making it easier to combine actuals with forecasts. It is also useful when inputs are provided to a few periods but need to be calculated with all forecast periods.
Syntax
Syntax
RangeToDAλ( Range, [Rows], [Columns] )
Arguments
Arguments
Range
(Required) A reference to the range to be converted.
Rows
(Optional) How many rows to have in the final array. Default = 1.
Columns
(Optional) How many columns to have in the final array. Default = 1.
Example
Example
In this example we are converting actuals and a static input to dynamic arrays spanning all model periods,.
Page updated
Google Sites
Report abuse