@Member (Formula Language)

Given a value, finds its position in a text list.

Syntax

@Member( value ; stringlist )

Parameters

value

Text. The value you want to find in stringlist.

stringlist

Text list.

Return value

position

Number

  • Returns 0 if the value is not contained in stringlist
  • Returns 1 to n if the value is contained in the stringlist, where 1 to n is the position of the value in the stringlist

Examples

  1. This example returns 0.
    @Member("Sales";"Finance":"Service":"Legal")
  2. This example returns 12 if the value in the ReportName field is the 12th value in a list contained in the RequiredReading field; otherwise it returns 0.
    @Member(ReportName;RequiredReading)