Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Copy a Calculated Field

To copy a calculated field:

  1. Hover over the calculation in the Field List of the Data step and click on the drop down menu to open it. Select the Copy option.
    Image Added
  2. A confirmation popup is displayed, click on Ok to create a copy of the selected field.
    Image Added

The new field will have the same name as the old field with “Copy” appended to the end. You can rename this field as required. Note that copying calculated fields also works at subquery level.

Delete a Calculated Field

...

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

 

Expand
titleClick to view instructions...
  1. Bring up the menu on a calculated field, and select Totals.
  2. Then choose the Calculated Total option. This option is only available if the field is a calculation.



  3. The total summary of the calculated field will be added at the end of the report.


...