Loading
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
            Special Characters

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            Special Characters

            Certain characters have a special meaning in CRM Analytics.

            Character Name Description
            ‘ Single quote

            Encloses a dataset column name in a predicate expression.

            Example predicate expression:

            'Expected_Revenue' >= 2000.00

            “ Double quote

            Encloses a string value or field value in a predicate expression.

            Example predicate expression: 'OpportunityOwner' == "Michael Vesti"
            ( ) Parentheses

            Enforces the order in which to evaluate a predicate expression.

            Example predicate expression:

            ('Expected_Revenue' > 4000 || 'Stage Name' == "Closed Won") && 'isDeleted' != "False"

            $ Dollar sign

            Identifies the Salesforce object in a predicate expression.

            Note
            Note You can only use the User object in a predicate expression.

            Example predicate expression:

            'Owner.Role' == "$User.UserRoleId"

            . Period

            Separates the object name and field name in a predicate expression.

            Example predicate expression:

            'Owner' == "$User.UserId"

             
            Loading
            Salesforce Help | Article