Operators

You can use the following types of operators in formulas:

Table 18-1 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 Work with Member Combinations Across Dimensions.

For information about using operators with #MISSING, zero, and other values, see Operation Results on #MISSING Values and Zero (0) Values.