The available scalar functions include:
You can use a variety of scalar functions for adding computed data items in the Pivot, Chart, Tables and Results sections.
Scalar functions (in contrast to Data Functions) do not aggregate data or compute aggregate statistics. Instead, scalar functions compute and substitute a new data value for each value associated with a data item.
The following scalar functions are available:
In the tables for Conditional, Date, Math, String and Trend functions below, the variables n, s, d, and exp (and val) represent data items and columns (State, Amount Sold) or actual values (‘NY’, 6000) as arguments to scalar functions, and indicate number, string, date, or variable types, respectively. |
The variable c indicates that only a data item reference may be used, and not a constant value. If constant values are substituted for data items, dates and text strings must be enclosed in single quotes. Examples in the tables that follow use a mixture of constants and data items, which are generally interchangeable. |