1. Calculation functions
  2. All functions
  3. Miscellaneous functions
  4. FINDITEM

The FINDITEM function searches for a text value within the names and codes of the items or time periods in a given list or Time respectively. If the FINDITEM function finds a match, it returns the corresponding list item or time period.

For example, you could use the FINDITEM function to check if an item available in a certain region is available in other regions.

Syntax

FINDITEM(List or Time, Item to find)

Arguments

ArgumentData typeDescription
List or TimeList or Time dimension

The list to search within for the Item to find argument.

You can also use the time dimension and search for periods.

Item to findTextThe text to match against the name or code of the list item or time period to find.

The FINDITEM function returns a result of the list or time period data type, based on the given List or Time argument.

Syntax example

FINDITEM(USA Products, Product Name)

Constraints

Configuration of the result line item

If the List or Time argument is a list, the result line item must have the list data type, configured with the same list.

If the List or Time argument uses Time, the result line item must have the time period data type. The result the FINDITEM function returns depends on the time period granularity (for example, Month, or Quarter) of the line item.

Calculation engine functionality differences

You cannot use the FINDITEM function with Time in Polaris.

In the Classic Engine, you can.

Excel equivalent

LOOKUP

Examples

These examples refer to a Products list. The Products list contains the following items, as seen in the Grid View tab in General Lists.


ParentCodeFruit subsetVegetable subset
ApplesFruitAPP001
PeachesFruitPEA002
BananasFruitBAN003
FruitTotal Products

CarrotsVegetablesCAR004
CucumbersVegetablesCUC005
LettuceVegetablesLET006
VegetablesTotal Products

Total Products

List example

In this example, time is on columns, and there are three line items on rows.

The top-selling product for each month is manually entered into the Top-selling product line item on a dashboard. The Fruit product top seller? and Vegetable product top seller? line items use the FINDITEM function to return the top-selling product if it is a fruit or vegetable respectively.


Jan 22Feb 22Mar 22Apr 22May 22Jun 22
Top-selling productApplesBananasCucumbersCucumbersPeachesLettuce

Fruit product top seller?

FINDITEM(Fruit subset, 'Top-selling product')

ApplesBananas

Peaches

Vegetable product top seller?

FINDITEM(Vegetable subset, 'Top-selling product')



CucumbersCucumbers
Lettuce

List with codes example

This example demonstrates how codes for list items can be used to find items, instead of the text in list item names.


Jan 22Feb 22Mar 22Apr 22May 22Jun 22
Code of top-selling productAPP001BAN003CUC005CUC005PEA002LET006

Fruit product top seller?

FINDITEM(Fruit subset, 'Code of top-selling fruit product')

ApplesBananas

Peaches

Vegetable product top seller?

FINDITEM(Vegetable subset, 'Code of top-selling product')



CucumbersCucumbers
Lettuce

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.