---
schema_version: "1"
id: aa22488462d62d8c32dae6cf0048de63ced04ac6ca539d7ff906ed0d256b5d83
title: Sample Predicate Expressions for Datasets
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_sampleexpressions.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_security_datasets_predicate_sampleexpressions.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b1880341f66cfae232b86df1c426589232db353301be5da0b9fa39842f76505e
description: Review the samples to see how to structure a predicate expression.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Sample Predicate Expressions for Datasets

Review the samples to see how to structure a predicate expression.

The samples are based on the following Opportunity dataset.

     
| Opportunity | Expected\_Rev | Owner | OwnerRoleID | Stage\_Name | IsDeleted |
| --- | --- | --- | --- | --- | --- |
| OppA | 2000.00 | Bill | 20 | Prospecting | True |
| OppB | 3000.00 | Joe | 22 | Closed Won | False |
| OppC | 1000.00 | 可爱的花 | 36 | Closed Won | False |
| OppD | 5000.00 | O’Fallon | 18 | Prospecting | True |
| OppE |   | Joe | 22 | Closed Won | True |

Let’s take a look at some examples to understand how to construct a predicate expression.

 
| Predicate Expression | Details |
| --- | --- |
| `'OwnerRoleID' == "$User.UserRoleId"` | Checks column values in the User object. |
| `'Expected_Rev' > 1000 && 'Expected_Rev' <= 3000` |   |
| `'Owner' = "Joe" || 'Owner' = "Bill"` |   |
| `('Expected_Rev' > 4000 || 'Stage Name' == "Closed Won") && 'isDeleted' != "False"` | Parentheses specify the order of operations. |
| `'Stage Name' == "Closed Won" && 'Expected_Rev' > 70000` |   |
| `'Owner' == "可爱的花"` | String contains Unicode characters. |
| `'Owner' == "O\’Fallon"` | Single quote in a string requires the escape character. |
| `'Stage Name' == ""` | Checks for an empty string. |