Creating and using a calculated field | ClearPoint Strategy

Creating and using a calculated field

This article describes how to create calculated fields, which allow you to display series as columns in summary views. Values will only show up in a calculated field if the series included have the same name. Series data can be referenced from measure, initiative, milestone, action item, and risk data tables. The other way to display series in summary reports (regardless of name) is by using the Series Status column to create a heat map or matrix.

Feature available for Professional Plan and above

In This Article

Creating the calculated field

From under System Settings, click on Admin Options.

Click on Calculated Fields.

Click on Add Calculated Field. Give your calculated field a Name. Select a Data Type. If ‘Default’ is selected, the values for each measure will retain the data type for that measure.  We recommend using ‘Default.’ Use the Series Name and Aggregation dropdown menus to select the values to include in your calculation for each measure. Then, click Insert to add them to your calculation.

Use the operator buttons or your keyboard to add operators to your calculation as necessary. By clicking the Test button, you can test the calculation for a particular scorecard and reporting period. Learn more in the section below. When the calculation is complete, click Save.

Testing the calculated field

Once the calculation is determined, you can use the Test button to see how this calculated field would calculate for a particular measure. Click Preview to see up to 25 results from a scorecard for the calculation.

Use the Select Scorecard dropdown to choose a different scorecard to see the results for the calculation. Use the Select Period dropdown to choose a different period to see the results for the calculation.

Using the calculated field as a column in a summary report

Navigate to the summary report where you would like to use the calculated field. This must be a custom (as opposed to default) summary report. Click the edit pencil icon.

Click on the Columns tab. Click Add Column to add the calculated field to the report. Search by name or use the dropdown menu to the right of the search bar to filter by field type. Check the box next to the name of calculated field to the columns in your report. Click Save and then Save again.

Your calculation will appear as a column, as shown below. The default settings for whether a status color, icon, or no indicator is displayed can be set in your Report Options.