Overview of Operators for Calculated Data Items

In the explorer and the designer, you can calculate data items by using expressions that contain operators. The operators that you can use are grouped into the following categories:

Numeric (simple) operators

perform basic mathematical operations such as addition and multiplication. See Numeric (Simple) Operators.

Numeric (advanced) operators

perform advanced mathematical functions such as evaluating logarithms and truncating decimals. See Numeric (Advanced) Operators.

Boolean operators

evaluate whether a set of logical conditions is true. See Boolean Operators.

Comparison operators

evaluate how the values of your data items compare. See Comparison Operators.

Date and Time operators

convert values to, from, or between date and time formats. See Date and Time Operators.

Text operators

evaluate text values. See Text Operators.

Aggregated operators (aggregated measures only)

calculate aggregations for aggregated measures. See Aggregated Operators.