Logical operators in Planning Analytics rules
You can combine expressions in a rules calculation statement using logical operators.
Operator |
Meaning |
Example |
---|---|---|
& (ampersand) |
AND |
(Value1 > 5) & (Value1 < 10) Returns TRUE if the value is greater than 5 and less than 10. |
% (percentage sign) |
OR |
(Value1 > 10) % (Value1 < 5) Returns TRUE if the value is greater than 10 or less than 5. |
~ (tilde) |
NOT |
~(Value1 > 5) Equivalent to (Value1 <= 5) |