| 1. |
The following example returns an array of the elements at indices 1, 3, 5... .
{FILTER(Variables.ArrayData, Index MOD
2)}
|
| 2. |
The following example returns an array where each element represents the difference between each element in the source array and the previous element in the source array. The array that is returned can be referred to as the difference array. Since the first element in the source array has no previous element, it is ignored when calculating the difference array (therefore the StartIndex parameter of the SELECT function is set to 2 instead of 1). SELECT
(Flowchart.MyArray, 2, ItemCount - 1,
Item.Y -
Flowchart.MyArray(Index -
1).Y)
|