Calculated Measure tool

Use Calculated Measures with one or more existing measures in conjunction with mathematical operators to create results like Totals, Averages, Percentages, or more complex calculations.

1. Drag the Calculated Measure tool into the Measures area of a report.

The Calculated Measure configuration screen is displayed. For example:

2. Click the <New calculated measure> text to make this field editable, and enter a suitable name for the measure:
3. Select the Measures that will be used in the calculation by selecting them from the drop-down and clicking the + button. You will see that multiple iterations of the measure are available by default - these include All records - Total records - Row total of records and Page total of records.
4. Select the measure format using the numeric format helper.
5. The Visible check box is intended for use with calculated measures where one measure may be used by another, but wouldn't be displayed on its own in the final report. In this example you would clear the check box.
6. Use the available operators and functions to build up your expression. Use the button to validate the expression.

Here is a simple example of a calculated measure used in a grid used to display Males as a percentage of Total Customers:

The grid also contains a simple measure called Count of all Customers which is used in the calculation, and breaks the results down by a 'County' dimension. This results in the following grid:

• Reporting
  • Venn
  • Score Card
  • Profile Report
  • Gauge
  • Crosstab Grid
  • Charts
  • Report
  • Measure
  • Historical Performance
  • Calculated Measure
  • Comparison Measure
  • Dimension
  • Drill Query