Calculation operators (mathematical, conditional and logical, and cross-dimensional) define equations for member formulas and calc scripts.
Mathematical operators perform common arithmetic operations.
| + | Adds. |
| - | Subtracts. |
| * | Multiplies. |
| / | Divides. |
| % | Evaluates percentage. For example, Member1%Member2 evaluates Member1 as a percentage of Member2. |
| ( ) | Controls the order of calculations and nests equations and formulas. |
Conditional operators build logical condition into calculations.
| 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.
The cross-dimensional operator points to data values of specific member combinations.
| -> | The cross-dimensional operator is created with a hyphen ( - ) and a right angle bracket ( > ), with no space between them. |
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |