Operators

Table 47 lists the types of operators you can use in formulas:

Table 47. List of Operator Types

Operator Type

Description

Mathematical

Perform common arithmetic operations.

For example, you can add, subtract, multiply, or divide values.

See Mathematical Operations.

Conditional

Control the flow of formula executions based on the results of conditional tests.

For example, you can use an IF statement to test for a specified condition.

See Conditional Tests.

Cross-dimensional

Point to the data values of specific member combinations.

For example, you can point to the sales value for a specific product in a specific region.

See Working with Member Combinations Across Dimensions.

For information about using operators with #MISSING, zero, and other values, see the “Essbase Functions” section in the Oracle Essbase Technical Reference.