Embedded Files
Description
Description
ScheduleValuesλ() places values from a schedule table (or array) in a timeline's periods. The values populate only the effective date's period.
NOTE! If two values are scheduled within the same timeline period, they are totalled in the period.
Syntax
Syntax
ScheduleValuesλ(Values, EffectiveDates, Timeline, [EndDates?], [ItemIDs], [IncludeIDs])
Arguments
Arguments
Values
(Required) Values to be scheduled.
EffectiveDates
(Required) Dates determining when a value is effective.
Timeline
(Required) The model's timeline.
EndDates?
(Optional) TRUE=Timeline displays period end dates. Default = TRUE
ItemIDs
(Optional) A list that identifies what item in a group each rate applies to.
IncludeIDs
(Optional) A list of one or more ItemIDs to include. One ID per result row.
Example
Example
In this example we are scheduling values to be expensed. On the left we have a table of effective dates and amounts. Over our function is a timeline of period end dates. The order of entries in the table is unimportant. The values and effective dates can be in a horizontal layout. No table is needed but we lose the dynamic advantages of structured references.
In this example we are scheduling values to be expenced by item.
Page updated
Google Sites
Report abuse