Insert formula

You can add functions to the spreadsheet in order to perform calculations, for example.

Prerequisite

A table view is created for the query or the ad-hoc analysis.

Procedure

  1. Start the query or the ad-hoc analysis.

  2. Click Output Output if the table is hidden.

  3. Activate the Data tab bar.

  4. If you are editing a query, click the Template table.

  5. Click in a cell.

  6. Click Formula Insert formula > Insert formula. The Insert formular dialog opens.

  7. Click the relevant formula.

  8. Click OK. The formula is inserted in the cell.

  9. Determine the area to which a calculation will be valid, e.g, for cells A1 to A5. You do not have to enter the area, you can select it by holding down the mouse button.

  10. Press Enter.

You have inserted the formula.

The table result is updated once you have clicked Evaluate table Evaluate table in the Start tab bar.