> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.close.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.close.com/_mcp/server.

# Calculations in Smart Views

> Add column calculations to Smart Views and searches in Close. Show totals, averages, and percentages at the bottom of any column without exporting.

## Smart View Column Calculations

Smart View column calculations let you quickly summarize your data—right inside Close.\
You can see totals, averages, percentages, and more at the bottom of any Search result or Smart View column, without exporting to a spreadsheet.

Once added, calculations are saved with the Smart View, so anyone you share it with will see the same results.

---

## How Column Calculations Work

At the bottom of a supported column, you'll see a **Calculation** option.

1. Open a Search result or Smart View
2. Scroll to the bottom of a column
3. Click **Calculation**
4. Choose the calculation you want to apply

Your selected calculation appears instantly and updates automatically as the underlying data changes.

---

## Why Use Column Calculations?

Column calculations help you answer common questions about your data—fast.

Instead of exporting data or building formulas elsewhere, you can understand what's happening directly where you work.

Some examples:

* See the **average call duration** for a filtered list of calls
* Track the **percentage of calls with an Outcome assigned**
* Monitor how often a **custom field is filled in**
* Calculate **totals**, like revenue stored in a custom field
* Find the **highest or lowest values** in a column

---

## Available Calculations

### Numeric Columns

For numeric fields, you can choose from:

* Count Empty
* Count Not Empty
* Percent Empty
* Percent Not Empty
* Sum
* Average
* Median
* Minimum
* Maximum

These are useful for call duration, deal value, revenue, and any numeric custom field.

![Dropdown menu showing calculation options like count, percent, sum, average, median, minimum, and maximum.](https://close-prd-help-docs.s3.us-west-2.amazonaws.com/feature-guide/lead-filtering-and-smart-views/calculations-in-smart-views/column_calculation_menu_1135de.png)

---

### Non-Numeric Columns

For text-based or non-numeric fields, you can use:

* Count Empty
* Count Not Empty
* Percent Empty
* Percent Not Empty

This is especially helpful for checking data completeness, such as whether required fields are consistently filled out.

![Dropdown menu showing Count empty, Count not empty, Percent empty, Percent not empty, and Clear calculation options.](https://close-prd-help-docs.s3.us-west-2.amazonaws.com/feature-guide/lead-filtering-and-smart-views/calculations-in-smart-views/non_numeric_calculation_menu_876679.png)