Report Formula
1. What is a report formula?
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.
2. On what views can I create a report formula?
Report formulas are only supported for the following report types:
- Chart
- Pivot Table
- Summary View
3. How do I create a report formula?
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.
4. How do I edit report formulas?
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.
5. Can I use the report formulas of one report in another?
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.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Unexpected error prompted for while accessing reports for Servicedesk Plus MSP integrated setup
Issue : Unexpected error prompt while accessing reports Analysis: The exception caused is due to a syntax problem faced in the query formed while the user filter drop down is used on the SLA deviation report. The logs shared helped us to find the ...Xero Advanced Analytics
Zoho Analytics advanced analytics for Xero enables you to slice and dice your financial data and derive great insights. You can analyze and create reports such as financial overview, bill trend, pending invoices and do much more with Zoho Analytics. ...Zendesk Advanced Analytics
Zoho Analytics advanced analytics for Zendesk enables you to easily analyze your data in Zendesk and keep track of key help desk metrics. This helps support managers slice and dice their help desk data and create and analyze reports such as agents' ...Teamwork Desk Advanced Analytics
Zoho Analytics for Teamwork Desk enables you to easily analyze your helpdesk data in Teamwork Desk. With this, you can slice and dice your helpdesk data for analysis and derive key metrics to transform them into actionable business insights. General ...Integration with Zoho CRM
Zoho Analytics seamlessly integrates with Zoho CRM, and enables you to analyze your Zoho CRM data easily and keep track of key metrics. This helps managers create intuitive reports on your campaigns, invoices, purchase orders, and much more. General ...