Embedded Files
Description
Description
SumPeriodsλ() is a general purpose function for totalling by reporting periods things that were schedule by smaller periods. In this example we have a table of scheduled amounts that specifies an amount, start date, and how often it repeats. To the right of that list is a 5G function that schedules those amounts by day for an entire year. Below that we use SumPeriodsλ() to total those amounts by reporting period, which, in this case, is by month.
Syntax
Syntax
SumPeriodsλ( Values, ValuesTimeline, ModelTimeline, [EndDates?])
Arguments:
Arguments:
Values
(Required) A two dimensional array/range containing values to be totaled where each column is for a specific period.
ValuesTimeline
(Required) The timeline for the Values array.
ModelTimeline
(Required) The model's timeline which is for periods larger than the ValuesTimeline.
EndDates?
(Optional) Specifies the model's timeline is period end dates (TRUE) or start dates (FALSE). Default = TRUE.
Page updated
Google Sites
Report abuse