HAS

Checks whether a specified value exists within a list and returns TRUE or FALSE.

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 list of 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