Loading
Salesforce now sends email only from verified domains. Read More
CRM Analytics
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
            Comparison Operators

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            Comparison Operators

            Comparison operators return true or false.

            CRM Analytics supports the following comparison operators.

            OperatorNameDescription
            == Equals

            True if the operands are equal. String comparisons that use the equals operator are case-sensitive.

            Example predicate expressions:

            'Stage Name' == "Closed Won"
            != Not equals

            True if the operands are not equal. String comparisons that use the not equals operator are case-sensitive.

            Example predicate expression:

            'isDeleted' != "False"
            < Less than

            True if the left operand is less than the right operand.

            Example predicate expression:

            'Revenue' < 100
            <= Less or equal True if the left operand is less than or equal to the right operand.
            > Greater than True if the left operand is greater than the right operand.
            >= Greater or equal True if the left operand is greater than or equal to the right operand.
            in Multivalue list filter

            True if the left operand exists in the list of strings substituted for a multivalue picklist (field value).

            Example predicate expression:

            'Demog' in ["$User.Demographic__c"]

            In this example, Demographic__c is of type multiPicklistField. During evaluation, the multivalue picklist field is substituted by a list of strings, with 1 string per user-selected item.

            Note
            Note Comma-separated lists are not supported within the square-bracket construct.

            You can use the <, <=, >, and >= operators with measure columns only.

             
            Loading
            Salesforce Help | Article