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
Equals([LIST], search string)
- 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")}