Function Index

Choose

Returns the value with the corresponding index position. When an index number is provided and a corresponding value does not exist, a Null result is returned.

Usage

Choose(<index Number>,<value 1>, <value 2>…)

index number (required) The index number of the value returned. Index value needs to be a number, a formula or column that references a number.

value 1 (required) The values from which to choose. At least one value must be provided.

value 2+ (optional) Additional values are optional.

Examples

Choose(1, "value 1", "value 2", "value 3")
  • Returns value 1.
Choose(Weekday([Date]), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")
  • Returns the name of the day of the week falling on the date in the [Date] column.