Some applications make use of an pattern to e.g. determine an schedule for active/non-active weeks. The pattern output exists of 0 (not-active) or 1 (active). This aggregate functoid can be used to create a range of 1's and 0's according to an input list (array) of records.
Inputs with their allowed values:
Start date of the period.
Mandatory to function is an concat with an '|' as separator and an group function. Please look at the example for the right setup of an range.
Number of weeks
Date format. Make sure the Start and Range dates are set to the same format!
- When an empty range is received (the Range only contains |), it will return 0'. The amount is based on the NumOfWeeks value.
- When the Start or End date value is not within the defined range, you will receive a "'count' must be non-negative." error.