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
            iferror

            You are here:

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

            iferror

            Checks whether an expression results in an error or null value in Salesforce Spiff and either returns the result of the expression or returns a default value for error handling. This function provides an alternative nested if() statements, but this function can also disguise real errors and result in inaccurate calculations if not used carefully.

            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

            iferror(expression, error_expression)

            Arguments

            Argument Required? Description
            expression Required The condition to test.
            error_expression Required The error handling to execute when the expression results in an error or null value.

            Considerations

            Important
            Important Don't use this function if you can't diagnose the source of an error.

            This function doesn't discriminate which errors to handle. For example, maybe you're trying to prevent a divide-by-zero error for this formula.

            if(DenominatorField = 0, 0, DivisionCalculation)

            When you use iferror(DivisionCalculation, 0), an error can occur in the numerator, denominator, or any part of the calculation. Each error returns 0 with no error message.

            The iferror() function also breaks the trace. If the if(DenominatorField = 0, 0, DivisionCalculation) expression includes ARR divided by quota, attainment appears as 0 on the statement and ARR and quota appears as 0 or not a number for the record. When you specify a divide-by-zero check, you see the values for ARR and quota if they exist.

            Example

            A rep has a custom rate assigned by a quota table, and you want to check whether the rate for a rep is empty. If so, prompt the admin to specify a rate for the rep. For the expression to test, calculate the rep's rate. For the error_expression argument, use the error() function to show a message for resolving the error condition.

            =iferror(DealMRR * AESpecialRates, error(concat(["Enter rates for", rep.name, "on the AESpecialRates quota page."])))
            Tip
            Tip The iferror() function is helpful when you're creating calculations and want to test for missing logic or variables. To prevent errors in production logic, use the iferror() function only during development and testing.

            See Also

             
            Loading
            Salesforce Help | Article