Essbase Conditional and Logical Operators

Conditional operators build logical condition into calculations.

Operator Description
IF | ELSE | ELSEIF | ENDIF Tests conditions and calculates a formula based on the success or failure
of the test.
> Data value is greater than.
>= Data value is greater than or equal to.
< Data value is less than.
<= Data value is less than or equal to.
= = Data value is equal to.
< > or != Data value is not equal to.
AND Logical AND linking operator for multiple value tests. Result is TRUE
if both conditions are TRUE. Otherwise the result is FALSE.*
OR Logical OR linking operator for multiple value tests. Result is TRUE
if either condition is TRUE. Otherwise the result is FALSE.*
NOT Logical NOT operator. Result is TRUE if condition is FALSE. Result
is FALSE if condition is TRUE.*

* The logical constants TRUE and FALSE are interpreted as 1 (TRUE) and
0 (FALSE) where appropriate.