Loading
Feature degradation | Gmail Email delivery failureRead More
Sales Performance Management
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            ifnull

            You are here:

            1. Salesforce Help
            2. Docs
            3. Sales Performance Management

            ifnull

            Replaces a null value in a field with a specified value in Salesforce Spiff.

            Required Editions

            Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience
            Available in: Enterprise, Unlimited, and Developer Editions
            Available for an additional cost in: Professional Edition with Web Services API Enabled

            Syntax

            ifnull(field, if_null_value)

            Arguments

            Argument Required? Description
            field Required The field to check for a null value.
            if_null_value Required The value to use for the field if the current value is null.

            Example

            Check whether the ARR__c field is null, and replace any null values with 0.

            =ifnull(ARR__c, 0)
             
            Loading
            Salesforce Help | Article