For the complete documentation index, see llms.txt. This page is also available as Markdown.
INDEXOF
Returns the index of the first occurrence of a specified number in an array.
The INDEXOF function returns the index of the first occurrence of a specified number within an array of numbers. It accepts numeric values or node references as arguments. If the value is not found in the input array, the function returns 0.
Syntax
INDEXOF(list,value)
Arguments
list - The input array of numbers to be checked (Required).
value - The number to be searched for in the list (Required).
Example
INDEXOF([LIST],VALUE)
In the example below, the INDEXOF function is used to check whether the Revenue in any quarter is equal to the Sales for Q1.
