Equals

Returns a subset of elements in a list based on a string search on captions. The search is based on an "equals" operation.

Syntax & Usage

• Create a list from which you want to derive the subset of elements.
• Add the Equals block to the list; go to the Insert Arguments window and enter the "Text to search for".
• Select "Exclude from Result Set" if you want to remove the searched elements from the list (as opposed to creating a list from them).

Example

Here the term "esics" is searched from the Manufacturer hierarchy, and Esics is returned:

{Equals({AllMembers([manufacturers].[Manufacturer])},"esics")}