Report Formula
- What is Report Formula?
- On what views can I create a Report Formula?
- How do I create a Report Formula?
- How do I edit Report Formula?
- Can I use Report Formula from one report in the other?
1. What is Report Formula?
Report formula is a formula column specific to a particular report. It differs from Formula Column and Aggregate Formula which are based over a table (which are then available for creating any report on top of the table).
Report Formula allows you to use the basic arithmetic operators such as +, -, * and / over the columns dropped in the Data shelf of the report. The report formula will be added as a metric in the report.
2. On what views can I create a Report Formula?
You can create Report Formula over the following report types:
- Chart
- Pivot Table
- Summary View
3. How do I create a Report Formula?
You can create a Report Formula from the report editor. Follow the below steps to create a Report Formula.
- Open the report in Edit mode.
- Click the icon.
For Charts, this will be available on the left of the data shelves. For Pivot Table and Summary View, this will be available on the right of the data shelves. - The Add Formula dialog will open. Provide a name for your Formula.
- Select the Data type of the column.
-
Specify the formula in the editor. You can perform any calculations in the report using the metric in the report. Report formula supports IF condition, and the following arithmetic operators, logical operators, and comparison operators.
- Arithmetic Operators - +, -, *, /, and ()
- Comparison Operators - >, <, >=, <=, =, and !=
- Logical Operators - and, or, and null
- Click Save. The created Report Formula will be added as a metric in the report.
Note: It will not be added as a column in the table.
4. How do I edit Report Formula?
You can edit a Report Formula by following the steps below.
- Open the report in Edit mode.
- Click the column in the Data shelf and then click Edit Formula.
- The formula dialog will open. Edit the formula as required.
5. Can I use a Report Formula of one report in another report?
No, formulas created over a report are specific to that report alone, and cannot be used in other reports.
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:
Zoho FSM Video Tutorials
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
Formula Column
Zoho Analytics allows you to define your own powerful formulas to meet your specific reporting requirements. This enables you to easily perform from simple calculations such as addition and subtraction to a complex combination of in-built functions. ...Creating Your Own Metrics with Formulas
Zoho Analytics with a powerful formula engine allows you to derive new business metrics from your data. This allows you to perform complex analysis and get the required insights from your data set. Zoho Analytics provides a set of in-built ...Aggregate Formulas
In reporting the most common data analysis that we do is to apply aggregate functions over the data (like SUM, AVG, COUNT etc.,) and analyze the same. The important aspect to be taken care in such calculations is to compute the aggregation in the ...How to Add Aggregate Formula Directly from Reports
The following are the steps to add an aggregate column directly from reports pag Open the reports tab in edit mode. Click Add Aggregate Formula link. The Add Aggregate Formula dialog box will open. Specify the formula name. Choose the data type. ...Advanced Analytics for Sage Accounting
Advanced Analytics for Sage Accounting helps you to analyze your key financial metrics, such as accounts, expenses, invoices, and many such KPIs. With this connector, you can create insightful reports and dashboards on your financial data and thereby ...