---
schema_version: "1"
id: 65ea13653db1c8713b61bea77a8b6e31f165268c90500cd0e3a7ac4ee737452b
title: Handle Null Values for Imported Data in Salesforce Spiff
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_import_null.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_import_null.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 4b0084d19956c8cb35b7900e7b62381311a06da2dc2a4238c98b02a3aa7ede04
description: Sometimes when you sync or import data in Salesforce Spiff, fields contain a null value. When Spiff calculates commissions, null values can cause issues because Spiff expects a value for a field, even if the value is zero. To handle null values with imported data, apply a default value for the field in all plans and rules. To handle null values for a specific rule or plan, first create a field on the rule or plan and then specify null handling for that field.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Handle Null Values for Imported Data in Salesforce Spiff

Sometimes when you sync or import data in Salesforce Spiff, fields contain a null value. When Spiff calculates commissions, null values can cause issues because Spiff expects a value for a field, even if the value is zero. To handle null values with imported data, apply a default value for the field in all plans and rules. To handle null values for a specific rule or plan, first create a field on the rule or plan and then specify null handling for that field.

### 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: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d99069e76">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d99069e76 ">To apply a default value:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d99069e76 ">
              <p>A Spiff <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_users_roles_and_permissions.htm&amp;release=264.0.0&amp;type=5" title="Give users the appropriate level of access so they can be successful in Salesforce Spiff, and enforce the principle of least privilege. Assign a default role to each user, or create custom roles with access to specific Spiff functionality.">user role</a> with this permission turned on.</p>
              <p style="margin-bottom:0;">Designer Configuration: Manage</p>
            </td>

          </tr>
        </tbody>
      </table>

1. Search or browse for the field that you want to set a default value on.
2. Select the field and open the right panel.
3. Under Format, turn on **Apply Default Value**.
4. Enter a default value.
    - For a number or currency data type, enter a number.
    - For a string data type, enter text, such as a placeholder that tells users what value to enter.
    - For a date data type, select a default date.
    - For a Boolean data type, enter True or False.