Insert formula directly

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. Enter an equal sign. The available formulas are listed.
  7. Enter the initial letter of the required formula. The corresponding formulas are displayed.
  8. Click the relevant formula. The formula is inserted.
  9. If required, enter the necessary parameters.
  10. Press Enter.

You have added a function to the spreadsheet.

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