List.Numbers

Syntax

List.Numbers(start as number, count as number, optional increment as nullable number) as list

About

Returns a list of numbers given an initial value, count, and optional increment value. The default increment value is 1.

  • start: The initial value in the list.
  • count: The number of values to create.
  • increment: [Optional] The value to increment by. If omitted values are incremented by 1.

Example 1

Generate a list of 10 consecutive numbers starting at 1.

List.Numbers(1, 10)
1
2
3
4
5
6
7
8
9
10

Example 2

Generate a list of 10 numbers starting at 1, with an increment of 2 for each subsequent number.

List.Numbers(1, 10, 2)
1
3
5
7
9
11
13
15
17
19