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.
| Function | Formula example | Description |
| SELECT | Sales.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. |
| FINDITEM | FINDITEM(#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. |
| NAME | NAME(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. |
| LOOKUP | People 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. |
| SUM | Project 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.
