---
schema_version: "1"
id: 64fec30180bee2a9e0c2c48d6bb4a3541792ca23f20b93bf0639a2fda51b8059
title: Considerations for Custom Calculated Columns in Pipeline Forecasts
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/forecasts3_considerations_custom_columns.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.forecasts3_considerations_custom_columns.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d669927965233e0e463ffbde9270260d5a7a5d8de473d1daaab439683344846f
description: Before you add custom calculated columns to your forecast types, review some considerations.
products:
  - Sales Cloud
release: "264"
---
# Considerations for Custom Calculated Columns in Pipeline Forecasts

Before you add custom calculated columns to your forecast types, review some considerations.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Professional</strong>, <strong>Performance</strong>, and <strong>Developer</strong> Editions and in <strong>Enterprise</strong> and <strong>Unlimited</strong> Editions with Sales</td></tr></tbody></table>

- Each forecast type can include up to five custom columns, which includes custom calculated columns and columns that show external data.
- The default Opportunity Amount forecast type includes Gap to Quota and Pipe Coverage columns. These columns are shown if you add quota data to Salesforce and count as part of the 5 custom columns for that type.
- On the forecasts page, custom calculated columns don’t show changes in the last 7 days and aren’t included in rollups.
- You can’t adjust custom calculated columns in forecasts.

If you have at least one custom calculated column in an active or inactive forecast type, you complete these actions until the column is removed.

- Switch from single category to cumulative rollups in Forecast Settings.
- Enable the Most Likely category.
- Disable Show Quotas (if your custom column’s formula refers to a quota value).

#### See Also

- [Add Custom Calculated Columns to Pipeline Forecasts](https://help.salesforce.com/s/articleView?id=sales.forecasts3_create_custom_columns.htm&release=264.0.0&type=5 "To track metrics that help to generate more accurate and data-driven forecasts, add columns that show values calculated using a formula that you define.")