The following sections describe the operators available for creating computed items. Use the following guidelines as you add operators to your computation. Click the Operator buttons in the Computed Item dialog box to add arithmetic or logical operators to a computation in the Definition text box. Operators are added at the insertion point. You can use any of the following types of operators:
Type the word null (no quotes) into the Expression text box to represent null values.
Enclose all text string constant values and date constant values entered in expressions in single quotes. (Numbers can be entered without quotes.)
To join items with a space or other character, reference or type items and strings into the Expression text box and join them with the + operator (for example, City + ‘,’ + State). To join without additional characters, use the Concat function.
In division operations, the divisor may not be null or equal to zero. If a data item serves as the divisor in an expression (for example, 5000 / Units_Sold) and includes null or zero values, first create a computed item using if/else logic to remove null and zero values, and then compute the item containing the division operation.
Two date items can be subtracted, but not added. The Add Month function adds an integer value to a date.
You cannot nest functions inside the Sum, Cume, Chr, and Breaksum functions.