Boolean operators are used to implement logic branches in formulas. They are available as operators within calculated key figures. You can use the following Boolean operators to make comparisons in formulas:
Is less than: <
Is not equal to: <>
Is greater than: >
Is less than or equal to: <=
Is equal to: =
Is greater than or equal to: >=
Logical NOT, AND, OR, and logical exclusive OR
For example, the formula Sales Volume > 100,000 delivers the value '1' if the sales volume is greater than 100,000. Otherwise, the expression delivers the value '0'.
The following figure shows you an example for a bonus calculation with the support of Boolean operators.
