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. |
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. |
For information about using operators with #MISSING, zero, and other values, see Operation Results on #MISSING Values and Zero (0) Values.