Zoho Analytics provides an option called Report Formula, which enables you to perform specific calculations on the metrics used in a particular report.
- What is a report formula?
- Are report formulas supported in all report types?
- How do I create a report formula?
- How do I edit report formulas?
- Can I use the report formulas of one report in another?
Report formula is a form of calculated metric that is specific to a particular report. While Formula columns and Aggregate Formulas are applied and associated to a data table, report formulas are applicable to only the report they are created over. Using this option, you can perform basic operations on the columns dropped in the Y-axis shelf for chart views, and in the Data shelf for pivot and summary views.
Report formulas are only supported for the following report types:
- Pivot Table
- Summary View
Follow the below steps to create a report formula.
Open the report in Edit mode and click the formula icon.
In the Add Formula page that appears, provide the formula column name and select the data type.
Specify the required formula in the editor. You can perform basic arithmetic, logical and comparison operations using the metrics in the report. The allowed operators are: + , - , * , / , (), >, <, >=, <=, =, !=, AND, OR and NULL.
Click Save. The created Report Formula will be added as a metric to the report.
The following presentation explains how to calculate magic number, which is a widely used formula to measure sales growth.
Follow the steps below to edit a report formula:
Open the report in Edit mode.
Navigate to the report formula metric and click Edit Formula.
- The formula dialog will open. Edit the formula as required.
No. Formulas created over a report are specific to that report alone, and cannot be used in other reports. To create formulas that can be reused in several reports, create the formula in the base table. Click here for more information.