Loading
Extend Salesforce with Clicks, Not Code
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
            VALUE

            You are here:

            1. Salesforce Help
            2. Docs
            3. Extend Salesforce with Clicks, Not Code

            VALUE

            Converts a text string to a number.

            Use

            VALUE(text) and replace text with the field or expression you want converted into a number.

            Tips

            Make sure the text in a VALUE function doesn’t include special characters other than a decimal point (period) or minus sign (dash). If the text in a VALUE function is a non-numerical/invalid format, the formula isn’t calculated and resolves to a blank value. For example, the formula 1 + VALUE(Text_field__c) produces these results:

            • If Text field is 123, the result is 124.
            • If Text field is blank, the result is blank.
            • If Text field is $123, the result is blank.
            • If Text field is EUR123, the result is blank.
            Lead Number
            Lead Number

            VALUE(Lead_Number__c) returns a number for the text value in the auto-number field Lead Number. This function is useful if you want to use the Lead Number field in a calculation. Note that auto-number fields are actually text fields and must be converted to a number for numeric calculations.

            Round Robin Lead Assignment
            Round Robin Lead Assignment MOD(VALUE(Lead_Number__c), 3)

            This formula is for a custom formula field named Round_Robin_ID that assigns each lead a value of 0, 1, or 2. This formula uses a custom auto-number field called Lead Number that assigns each lead a unique number starting with 1. The MOD function divides the lead number by the number of lead queues available (three in this example) and returns a remainder of 0, 1, or 2. Use the value of this formula field in your lead assignment rules to assign lead records to different queues. For example:

            • Round_Robin_ID = 0 is assigned to Queue A
            • Round_Robin_ID = 1 is assigned to Queue B
            • Round_Robin_ID = 2 is assigned to Queue C
             
            Loading
            Salesforce Help | Article