Edit or delete a calculated field

Use these instructions for managing your calculated fields.

To edit a calculated field:

1. In the Columns panel, click the Measures tab.
2. In the Measures list, right-click the desired calculated field, and select Edit Calculated Field.
3. In the Edit Calculated Field dialog, do any of the following as desired:
   • To clear the entire expression in the Expression box, click Clear All and then rebuild the expression.
   • To replace part of the expression, use the backspace key to remove the part you want.
   • To add a measure, in the Measures list, click the desired measure, and select the calculation type from the pop-up menu.

   • To add an operator between measures, type a mathematical symbol (+ - * /) or click the Functions button, and select a function.

     

4. Do one of the following:
   • To save the measure as a new measure, click Save As and then, in the Save As dialog, select a location for the measure. In the Name field, type a new name. Click Save and Return.
   • Click Save.

To move a calculated field:

1. Right-click the calculated field, and select Cut.

2. Select the desired location / folder in the Measures tab, right-click and select Paste.

   TIP: You can also drag and drop calculated fields to different locations in the Measures tab.

To delete a calculated field:

1. In the Measures tab, right-click the calculated field, and select Delete.

2. In the confirmation dialog, click OK.

   NOTE: You cannot delete calculated fields that are attached to a report.