Overview

Remove a Calculated Field from a Query

When a calculated field is removed from a query, it is no longer visible in the query results data table, but the calculated field remains available in the Field Selection, and can be easily re-added to the query.

To remove a calculated field from a query, do one of the following:

• In the Field Selection, within the Custom Fields section, click the desired field.
  
  
• In the Data section, click the gear icon in the column header of the desired field. Then, click Remove.

Edit a Calculated Field

To edit a calculated field, like to rename it or to change how it is calculated, do the following:

1. Open the Edit table calculation window by doing one of the following:
   
   
   • In the Field Selection, hover over the desired field. Click the More icon (see Field Selection Icons), and then click Edit.
     
     
   • In the Data section, click the gear icon in the column header of the desired field. Then, click Edit calculation.
     
     
2. In the Edit table calculation window, do the following:
   
   
   1. Update fields as desired.
      
      
   2. Click the Save button.

Delete a Calculated Field

To delete a calculated field, do one of the following:

• In the Field Selection, hover over the desired field. Click the More icon (see Field Selection Icons), and then click Delete.
  
  
• In the Data section, click the gear icon in the column header of the desired field. Then, click Delete.