Logical functions return a true or false answer that can be used in IF statements.

Logical functions return Boolean values such as 1/0, which is equal to true/false.

These functions are usually used to return a value that will be used inside a variable for filtering purposes or as indicators that we can use for sorting or display purposes.

For example, we can check whether the sales net gross measure contains a value or not and create a filter according to the result that the function will return.

The main logical functions are as follows: