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.
