---
schema_version: "1"
id: 0a703daee0ba1b49d8f7de1b4568427f65b7f37703502b6b4e9c7c3327bbe8cc
title: Handle Missing Values
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_missing_value_handling.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_missing_value_handling.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: da3ff85a9206dd67c6fd8e84934773e7d0acf38949a503f2fe39cb193969f2e0
description: Gaps in your data can throw off analysis. Missing values are best fixed in the source application by, for example, making it a required field. However, if you can’t do that, you can use CRM Analytics to fill in missing data.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Handle Missing Values

Gaps in your data can throw off analysis. Missing values are best fixed in the source application by, for example, making it a required field. However, if you can’t do that, you can use CRM Analytics to fill in missing data.

If your data has columns with missing values:

- Use a column profile in a recipe to determine if a column contains missing values and, if so, how many.
- Add the Predict Missing Values transformation to a recipe to fill in missing dimension column values.
- If possible, set a default value for null measures.
- Enable Null Measure Handling to properly handle null numeric values in source data.

#### See Also

- [Handle Null Numeric Values](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_null_measures.htm&release=264.0.0&type=5 "When you create or update a dataset through your dataflow, recipe, or a CSV upload, for example, CRM Analytics replaces blank numeric values with the specified default value. When no default value is specified, CRM Analytics replaces blanks in numeric columns with 0 or null based on whether you enable null measure handling.")
- [Profile Columns to Understand Data in a Data Prep Recipe](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_profile.htm&release=264.0.0&type=5 "In CRM Analytics, run column profiling on sample data to estimate key stats about columns, such as the frequency of values and percent of columns with missing values. Column profiling is especially useful when you are combining data from different sources, where inconsistencies are often introduced. Column profiles are available only for columns shown in preview.")
- [Predict Missing Values Transformation: Fill In Missing Values](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_predictmissingvalues.htm&release=264.0.0&type=5 "In CRM Analytic, use the Predict Missing Values transformation in a Data Prep recipe to complete your data by filling in missing values in a text column. CRM Analytics Intelligently predicts values based on values in other strongly correlated columns in your data.")