Calculation operators (mathematical, conditional and logical, and cross-dimensional) define equations for member formulas and calc scripts.
+ | 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. |
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 is created with a hyphen ( - ) and a right angle bracket ( > ), with no space between them. |
Copyright 1991-2002 Hyperion Solutions Corporation. All rights reserved.