# Two forecast-category fields: one set from stage, one reps keep

Coalescing them mixes two vocabularies, and only on closed deals.

By Ki Moon · 2026-06-15 · finding · current
Canonical: https://kihmoon.com/bench-notes/p/two-forecast-category-fields/

**Symptom:** Forecast-category breakdowns show values from two different picklists, and the mix concentrates on closed opportunities.

Salesforce opportunities carry a standard forecast category, and many teams add a custom one that reps maintain. The usual read takes the custom value when present and the standard value otherwise.

The two fields speak different vocabularies. The standard one follows the stage mapping, while the custom one follows the team's forecast call. Salesforce's Opportunity object reference says ForecastCategoryName is implied by StageName and updates automatically from the stage-category mapping when the stage changes, though it can be overridden.

Reps stop maintaining the custom field after close. So the coalesced value switches vocabulary exactly on closed deals. It takes the custom value where a rep left one and the standard value where they didn't.

The affected share can be small, but all of it is closed deals, the ones forecast accuracy is judged on.

In a synthetic test set of 300 opportunities, coalescing the two fields switched 58 of 144 closed deals to the stage-based vocabulary and none of the 156 open ones. The set shows the mechanism, not how common it is.

## Check your setup (read-only)

Compare the standard forecast category with the custom one on closed opportunities where both hold a value. If any closed deal reports a value from the other field's list, a custom-else-standard rule is mixing vocabularies.

**Passes if:** Every closed opportunity your reports or agents read takes its forecast category from one field's vocabulary only.

**Access needed:** crm-read, local-config

## If it fails (changes to make later, not part of the check)

1. Store the standard and the custom forecast category as 2 named fields. Never coalesce the 2 fields.
2. Tell the agent which field answers which question: the reps' call for the open forecast, the stage-based value for history.
3. Count closed deals where the 2 fields disagree before any forecast-category report.

**Applies if:** Your digests, routing or agents read forecast category, and your CRM has a custom forecast-category field alongside the standard one.

**Skip if:** Your CRM's opportunity object has no custom forecast-category field.

Tags: crm, data quality, measurement
