Operator and Precedence Value Matrix
The following table displays the probable value matrix for the Operator and Precedence columns of different Expression records.
|
Data Types
|
Value
|
Function
|
Field
|
|---|---|---|---|
|
Lookup
|
Yes
|
No
|
Yes
|
|
Picklist
|
Yes
|
No
|
Yes
|
|
Multi-Picklist
|
Yes
|
No
|
Yes
|
|
Checkbox
|
Yes
|
Yes
|
Yes
|
|
Number Formula (Number)
|
Yes
|
No
|
Yes
|
|
Currency
|
Yes
|
No
|
Yes
|
|
Auto Number (Name)
|
Yes
|
No
|
Yes
|
|
Text Formula (Text)
|
Yes
|
No
|
Yes
|
|
Percentage
|
Yes
|
No
|
Yes
|
|
Date
|
Yes
|
Yes
|
Yes
|
|
Date/Time
|
Yes
|
Yes
|
Yes
|
|
Email
|
Yes
|
No
|
Yes
|
|
URL
|
Yes
|
No
|
Yes
|
|
Text Area
|
Not Visible
|
Not Visible
|
Not Visible
|
|
Roll up summary
|
Yes
|
No
|
Yes
|
|
Phone
|
Yes
|
No
|
Yes
|
 |
Yes indicates that an operator is available for the corresponding data type and No indicates that an operator is unavailable for the corresponding data type.
|