## Overview

Calculated fields allow you to create basic calculations with the fields available in your report.

**Note:**a calculated field that you create in the report builder cannot be used across multiple reports. It is unique to your report only. If you create a set of calculated fields you wish to use across multiple reports you can either:

- Request the calculations to be included in the View by your administrator or
- Copy the report containing the calculations using the copy function – the copied report will contain the new calculated fields as well.

### Why Use Calculated Fields?

When an administrator designs a View they may not create all the variables that you are likely to need in the course of your report writing. The intention of a view is to provide you with sufficient fields for you to be able to write the report you need and to use some of these fields as the basis for more complex calculations.

## Simple Formula

Simple Formulas allow you to build calculations using the formula builder button interface. These may range from very simple addition or multiplication through to CASE statements.

## Pre-Defined Formula

Using a pre-defined formula you can add calculation to your report that will be based on formula rules defined by an administrator or are system default.

## Freehand SQL

If you have SQL skills you may wish to write your SQL directly into the SQL edit box. In this case select the ‘Enter SQL’ option from the formula tab. This will open the SQL edit box.

Insert the SQL you wish to create your column.

## Edit a Calculated Field

To edit a calculated field:

- Hover over the calculation in the Field List of the Data step and click on the drop down menu to open it
- Select the
**Edit Calculation**option

## Delete a Calculated Field

To delete a calculated field:

- Hover over the calculation in the Field List of the Data step and click on the drop down menu to open it
- Select the
**Delete**option

## Formatting Calculated Field Columns

Users can further format the resultant column of a calculated field. Click here for information on Column Formatting.

Note that a description setting is also provided for calculated field columns that allow users to provide a description to aid report writers to clearly understand the purpose and content of this field.

## Calculated Total

Much like dimension and metric fields, you can also create an aggregated total on a calculated field. This is done by using the Calculated Total option, which uses the calculation to create the total.

**Note:** Calculated Total is not supported in charts, except Numeric Display.