HAS

The HAS identifier checks if the specified value is part of the list. It can be used with formula columns, and data input columns (select, multi-select) and returns TRUE or FALSE.

Syntax

has(column1, [column2],..., searchvalue)

Arguments

column1, column2 - The list of columns where the search needs to be performed. The argument column1 is required and other columns are optional.

searchvalue - The value to be searched in the columns. This is a required argument.

Example

Let us consider the below scenario.

We need to check if the level is a leaf level and increase sales by 50%. This has been achieved using the HAS identifier as shown in the below image.

Using the HAS identifier