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.
