How to Create Formula Fields in HubSpot Custom Reports

Using HubSpot custom reports effectively means going beyond basic columns and learning how to create formula fields that calculate and compare the CRM data that matters most to your business. This guide walks you through every step of building, configuring, and using formula fields in the custom report builder so you can surface deeper insights from your records.

Formula fields let you compute values dynamically inside your reports without changing your underlying data. You can add them to most report types in the custom report builder, then refine them with filters, groups, and visualizations.

What Are Formula Fields in HubSpot Reports?

A formula field is a calculated field you add inside the custom report builder to transform existing properties into new metrics. Instead of exporting data to a spreadsheet, you can calculate important numbers directly inside your HubSpot reporting tools.

Formula fields can be used to:

• Calculate ratios, percentages, and averages
• Compare two properties from the same object
• Convert values (for example, from one time unit to another)
• Normalize information for easier trend analysis

These fields exist only in the report where you create them. They do not create or modify any CRM properties on your records.

Where You Can Use HubSpot Formula Fields

Formula fields are available in the custom report builder for most supported report types. When you create a report, you can add formulas to:

• Single object reports
• Cross-object reports
• Funnel reports (where supported)
• Custom reports using activities or custom objects

Some special report types and pre-built analytics tools may not support formulas. When in doubt, start with a standard custom report built from objects such as contacts, companies, deals, tickets, or custom objects.

How to Add a Formula Field in HubSpot Reports

The custom report builder provides a dedicated interface for building formula fields. Follow these steps to add your first formula:

Step 1: Open the HubSpot Custom Report Builder

1. In your account, navigate to Reports > Reports.
2. Click Create report.
3. Select Custom report builder.
4. Choose the objects and data sources that you want to use in your report.

After you select your data sources, you will enter the custom report editor where you can configure fields, filters, and charts.

Step 2: Add a New HubSpot Formula Field

1. In the left sidebar of the custom report builder, locate the Fields section.
2. Click Create field (or the equivalent option for creating a new field).
3. Choose Formula as the field type.

This opens the formula editor where you will define the calculation logic and output format for your field.

Step 3: Configure Formula Field Details

Before writing your expression, give your field clear identification:

• Name: Enter a descriptive name that makes sense to report users (for example, Deal Size per Contact).
• Description: Optionally, add a short description explaining what the formula calculates.
• Format / Data type: Choose the type of value you expect the formula to output, such as Number, Currency, Percentage, or Duration, depending on the options available.

The chosen format affects how the result is displayed in tables and charts.

Building Expressions in Your HubSpot Formula

Once the basic settings are in place, use the formula editor to reference fields and apply operations. The editor allows you to build expressions by combining properties, operators, and functions.

Referencing Fields

You can insert existing properties from your selected data sources into the formula field. Common examples include:

• Amount (deal amount)
• Number of pageviews (contact activity)
• Ticket time to close
• Custom number properties that store scores or counts

Use the sidebar picker or type to search for the property you want, then click to insert it into the formula expression.

Using Operators and Functions

Depending on the report builder version in your account, you will typically have access to operators such as:

• Addition, subtraction, multiplication, division
• Parentheses for grouping operations
• Comparisons and basic conditional logic (where supported)

The editor will validate your syntax and display errors if the expression is incomplete or incompatible with the selected data type.

Previewing and Saving the Formula

1. Review the formula expression for accuracy and alignment with your reporting goal.
2. Use any available preview pane to see sample output, if the interface offers it.
3. Click Save to add the formula field to your report.

The new field now appears in the Fields list and can be dragged into your chart or table like any other property.

Using HubSpot Formula Fields in Visualizations

After saving your formula, you can include it in charts, tables, and other visual components of your custom report.

Add the Formula to a Chart

1. In the report builder, choose a chart type such as column, bar, line, or area.
2. Drag your formula field into the Y-axis or Values area.
3. Use a property such as Create date, Close date, or Deal stage on the X-axis or Break down by area.

This allows you to visualize the calculated metric over time or across segments.

Display the Formula in Tables

1. Switch to a table view if your report supports it.
2. Add your formula field as a column.
3. Reorder the columns to place the formula near related properties, such as amount or count fields.

Tables are ideal for auditing the accuracy of a new formula, because you can compare its output to underlying source properties.

Best Practices for HubSpot Formula Reporting

To get reliable results from formula fields in your reports, keep these best practices in mind:

• Use clear naming: Include the unit or context in the field name, such as Revenue per Contact (USD).
• Minimize complexity: Start with simple operations, then layer more complexity only when needed.
• Test on small data sets: Filter to a narrower date range or sample segment to validate calculations.
• Document usage: Add descriptions so other users understand exactly how the formula is calculated.

Consider creating a reference report that lists all important custom formula fields your team relies on, making it easier for new users to interpret results.

Troubleshooting HubSpot Formula Fields

If your report does not behave as expected after adding a formula field, review the following areas:

• Data type mismatches: Ensure you are not combining incompatible field types, such as text and numbers.
• Null values: Some records may not have values in certain properties, which can affect calculated results.
• Filters: Check if a report-level filter is excluding records that you expected to see.
• Aggregation rules: Confirm how the report aggregates numbers (sum, average, count) when multiple records share the same dimension.

If issues persist, compare the calculations to a manual spreadsheet version using exported data to confirm the logic is correct.

Learn More About HubSpot Reporting

For the original product documentation on building and managing formula fields, consult the official HubSpot knowledge base article at this link. You will find up-to-date details on supported operators, limits, and interface changes.

If you need strategic help designing an analytics framework or optimizing reporting across marketing, sales, and service, you can also review consultancy resources such as Consultevo for broader CRM and analytics guidance.

By mastering formula fields in your custom reports, you turn raw data in HubSpot into flexible, actionable metrics tailored to your business model, giving teams clearer visibility into performance and trends.

Need Help With Hubspot?

If you want expert help building, automating, or scaling your Hubspot , work with ConsultEvo, a team who has a decade of Hubspot experience.

Scale Hubspot

“`