Boolean Operators are used to combine the logical expressions to produce a single output. Logical expression is a combination of one or more operands with a relational operator. Logical expression output is either true or false.
Boolean Operators in your system
I’m going to provide with a practical example on the operators. Please consider the formulas used and change their values as below:
LEAF Boolean operator is used to define hierarchy in the report. It will be started as 0 for the root node and proceeding downward to a leaf. The value for the result rows will be zero, while the elementary row (the last one in the hierarchy) will be shown as 1.
This operator can help you to have several types of calculation on result rows and elementary rows. Also, the result row will be always 0 if your report is not displayed in hierarchy.
Let’s suppose that you have created the key figure with the following formula LEAF(“COUNTER”), the result would be like the example below:
As you can see, the elementary row is the value for Product ID, so its result will be 1.
Table with examples for Boolean Operators
I hope you all have been able to understand a bit more on Boolean Operators. If you have any doubt, please do not hesitate on commenting them below. 🙂