Show All

Create a calculated field by using an expression

1. In the Data pane, click a blank column heading.
2. Type the expression for the calculation, and then press ENTER. Do not begin the expression with an equal sign (=).

   For example, if employees receive a commission that equals 15 percent of their total sales, you can calculate each employee's commission by adding the sales for each employee and then multiplying the total by 0.15.

   To see examples of expressions that use arithmetic operators, click .