Calculation Operators


Calculation operators (mathematical, conditional and logical, and cross-dimensional) define equations for member formulas and calc scripts.

Mathematical Operators

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 and Logical Operators

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.
ANDLogical AND linking operator for multiple value tests. Result is TRUE if both conditions are TRUE. Otherwise the result is FALSE.*
ORLogical OR linking operator for multiple value tests. Result is TRUE if either condition is TRUE. Otherwise the result is FALSE.*
NOTLogical 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.

Cross-Dimensional Operators

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.



Copyright 1991-2002 Hyperion Solutions Corporation. All rights reserved.