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
- Start the query or the ad-hoc analysis.
- Click
Output if the table is hidden. - Activate the Data tab bar.
- If you are editing a query, click the Template table.
- Click in a cell.
- Enter an equal sign. The available formulas are listed.
- Enter the initial letter of the required formula. The corresponding formulas are displayed.
- Click the relevant formula. The formula is inserted.
- If required, enter the necessary parameters.
- Press Enter.
You have added a function to the spreadsheet.
The table result is updated once you have clicked
Evaluate table in the Start tab bar.