Starts With
Returns a subset of elements in a list based on a string search on captions. The search is based on a 'starts with" operation.
Syntax & Usage
StartsWith([LIST], search string)
- Configure the list that should be filtered.
- Add the Starts With block to the list block; in the Insert Arguments window, enter the search string.
Example
In this example, a list of Manufacturers was configured, and the search string "o" set in the Starts With block. The function returns a list of elements in the Manufacturer hierarchy beginning with "o": Old Balance and Over Armour:
{StartsWith({AllMembers([manufacturers].[Manufacturer])},"o")}