AT.FIELDINDEX

This function returns the index number of a field name of an attribute table. An attribute table may have 254 fields defined.

Syntax

AT.FIELDINDEX(Database alias,Dimension,Attr_Tab_Id,Field)

Attr_Tab_Id is the number of the attribute table being examined (1, 2 or 3) and Field is the name of the field whose index number is being requested.

The Account dimension on the Best Practices sample database alias has two attribute tables and the fields in the first attribute table are "ElemType", "Name" and "OrderPosition" and "AccountType". This formula returns "4".

AT.FIELDINDEX("Best Practices OLAP","Account",1,"AccountType")

The first two and last arguments for this function may be strings or references to cells containing strings. Strings must be enclosed in quotes. The Attr_Tab_Id argument must be a number from 1 to 3 or a reference to a cell containing a number from 1 to 3.