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.

Usage

List.Numbers(1, 10)

Output

{
    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.

Usage

List.Numbers(1, 10, 2)

Output

{
    1,
    3,
    5,
    7,
    9,
    11,
    13,
    15,
    17,
    19
}