---
schema_version: "1"
id: 6ac4306757c7ddeec82c819b7a6c2c4a50098c6b789ced06b3a6b9347dc6aa87
title: Comparison Operators
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_security_datasets_predicate_operatorscomparison.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_security_datasets_predicate_operatorscomparison.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 7a91011608fa596618ec8f9fded82b3db39f8d760f937f9dfcd45bc5337cb12f
description: Comparison operators return true or false.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Comparison Operators

Comparison operators return true or false.

CRM Analytics supports the following comparison operators.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:9.407337723424272%">
          <col style="width:17.873941674506113%">
          <col style="width:72.71872060206961%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d144040e31">Operator</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d144040e33">Name</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d144040e35">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Operator" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e31 ">==</td>
            <td data-label="Name" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e33 ">Equals</td>
            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e35 ">
              <p dir="ltr">True if the operands are equal. String comparisons that use the equals
                operator are case-sensitive. </p>
              <p dir="ltr">Example predicate expressions:</p>
              <p style="margin-bottom:0;" dir="ltr"><code>'Stage Name' == "Closed
                    Won"</code></p>
            </td>
          </tr>
          <tr class="">
            <td data-label="Operator" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e31 ">!=</td>
            <td data-label="Name" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e33 ">Not equals</td>
            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e35 ">
              <p dir="ltr">True if the operands are not equal. String comparisons that use the not
                equals operator are case-sensitive.</p>
              <p dir="ltr">Example predicate expression: </p>
              <p style="margin-bottom:0;" dir="ltr"><code>'isDeleted' !=
                  "False"</code></p>
            </td>
          </tr>
          <tr class="">
            <td data-label="Operator" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e31 ">&lt;</td>
            <td data-label="Name" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e33 ">Less than</td>
            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e35 ">
              <p dir="ltr">True if the left operand is less than the right operand.</p>
              <p dir="ltr">Example predicate expression:</p>
              <p style="margin-bottom:0;" dir="ltr"><code>'Revenue' &lt; 100</code></p>
            </td>
          </tr>
          <tr class="">
            <td data-label="Operator" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e31 ">&lt;=</td>
            <td data-label="Name" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e33 ">Less or equal</td>
            <td data-label="Description" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e35 ">True if the left operand is less than or equal to the right
              operand.</td>
          </tr>
          <tr class="">
            <td data-label="Operator" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e31 ">&gt;</td>
            <td data-label="Name" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e33 ">Greater than</td>
            <td data-label="Description" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e35 ">True if the left operand is greater than the right operand.</td>
          </tr>
          <tr class="">
            <td data-label="Operator" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e31 ">&gt;= </td>
            <td data-label="Name" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e33 ">Greater or equal</td>
            <td data-label="Description" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e35 ">True if the left operand is greater than or equal to the right
              operand.</td>
          </tr>
          <tr class="">
            <td data-label="Operator" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e31 ">in</td>
            <td data-label="Name" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e33 ">Multivalue list filter</td>
            <td data-label="Description" dir="ltr" class="slds-cell-wrap" style="vertical-align:top;" headers="d144040e35 ">
              <p>True if the left operand exists in the list of strings substituted for a
                multivalue picklist (field value).</p>
              <p dir="ltr">Example predicate expression: </p>
              <p dir="ltr"><code> 'Demog' in
                    ["$User.Demographic__c"]</code></p>
              <p dir="ltr">In this example, <code>Demographic__c</code> is
                of type <code>multiPicklistField</code>. During
                evaluation, the multivalue picklist field is substituted by a list of strings,
                with 1 string per user-selected item. </p>
              <div class="slds-box slds-box_x-small slds-theme_shade slds-m-top_medium slds-m-bottom_medium">
                <div class="slds-media slds-media_responsive">
                  <div class="slds-media__figure"><span class="slds-icon_container slds-icon_container_circle slds-icon-note-note"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png" alt="Note"></span></div>
                  <div class="slds-media__body" style="padding-top:.5rem;padding-bottom:.5rem;"><span class="slds-text-title_caps">Note</span> Comma-separated lists are not supported within the square-bracket
                    construct.</div>
                </div>
              </div>
            </td>
          </tr>
        </tbody>
      </table>

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