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:
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
Zoho DataPrep 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 ...Adding Formulas
Formulas, as the name indicate are calculations that you could define in Zoho Analytics to help you create the required reports. Zoho Analytics provides a powerful formula engine to create any type of calculations required, to enable creating 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. ...QuickBooks Advanced Analytics
Zoho Analytics Advanced Analytics for QuickBooks Online empowers you with financial analytical capabilities over your QuickBooks Online data. With this connector you can create insightful reports & dashboards over your QuickBooks data for in-depth ...Basic concepts of Zoho Analytics
Zoho Analytics On-Premise is an installable reporting and business intelligence service that helps you to easily analyze your business data and create insightful reports & dashboards for informed decision-making. This guide will help you to learn ...