1. Modeling
  2. Dimensions
  3. Numbered lists
  4. Numbered lists and functions

Model builders can use different functions when working with formulas and numbered lists.

For example, you can use the functions in the table below with numbered lists.

FunctionFormula exampleDescription
SELECTSales.Gross Sales[SELECT: #Products.'#20']

In this example, the SELECT function identifies the value from the Gross Sales line item for a specific list item in the #Products numbered list.

Note: The SELECT function requires a list item's unique identifier that is automatically generated when each numbered list item is created.

Learn more in SELECT.

FINDITEMFINDITEM(#Employees, Employee Search)

In this example, the FINDITEM function identifies list items in the #Employees numbered list that match the employee name you want to search for.

The Employee Search line item must be a text value. You can use the TEXT function to convert numbers in the numbered list to text.

Note: The FINDITEM function requires a list item's code, or the unique identifier that is automatically generated when each numbered list item is created.

Learn more in FINDITEM and TEXT.

NAMENAME(ITEM(#Transactions))

The ITEM function identifies the list item in the #Transactions numbered list, and the NAME function converts the list item to text.

Learn more in NAME.

LOOKUPPeople Details.Days Available [LOOKUP:#Resources.Employees]

In this example, the LOOKUP function identifies list items in the #Resources numbered list, then pulls data from the Employees list property.

This data is used to look up the days available for each employee.

Note: Use the LOOKUP function with list-formatted properties.

Learn more in LOOKUP.

SUMProject Days.Days Booked[SUM: #Resources.Employees]

In this example, the SUM function identifies list items in the #Resources numbered list, then pulls data from the Employees list property.

This data is used to look up the days booked for each employee.

Note: Use the SUM function with list-formatted properties.

Learn more in SUM.

Learn more in Formulas.