You can add operators 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:
The following guidelines are applicable when using 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.