To create a derived metric on a report
In order to create a derived metric, you need to have DHTML enabled.
- Do one of the following:
- For a report: Click the name of a report to execute it.
- For a document: Open the document in Design Mode or Editable Mode, then select the report in the Layout area.
- From the Data menu, select Insert New Metric.
- If DHTML is disabled, click the Go check mark.
- In the Name field, type the name of the new metric.
- In the Definition field, type the formula to designate how the metric should be calculated. For example, type [Revenue]/[Profit].
- When using another metric with spaces or special characters in its name, place the name within brackets [ ]. For example, [$ Sales].
- You may use arithmetic operators and parentheses in the formula. For example, the formula for a derived metric called Profit may be [$ Sales] – Cost
- If DHTML is enabled, you can select a metric from the Available list and add it to the Definitionarea.
- To create a more advanced derived metric, for example, Running Sum of Revenue or Average of Daily Website Hit Counts, you can define the metric based on a function. To access a list of functions you can use, click the Function Wizard icon before adding anything to the Definition pane.
- Click OK to create the new metric.
For information about using functions for derived metrics, see Creating a derived metric on a report using a function.
How to create a derived metric on a report: To create a derived metric on a report In order to create a derived metric, you need to have DHTML enabled. Do one of the following: For a report: Click the name of a report to execute it. For a document: Open the document in Design Mode or Editable Mode, then select the report in the Layout area…