Overview
To add, subtract, multiply, and delete, use standard mathematical operators (+, -, *, /). E.g.,
OPEX__m.actual__d * .20
Total_Budget__c - Total_Expense__c
sumIf(Initiative__t, Head_Count__c) / countIf(Initiative__t)
To compare one value to another, user equals (=), not equals (!=), greater than (>), less than (<), greater than and equal to (>=), and less than and equal to (<=). E.g.,
Expense_Budget >= Salary__c + CAPEX__c
LOE_Estimate__c < days(Stage_2_Start__c, Stage_1_Start__c)
if(Average_Score__c >= 1 and Average_Score__c < 5, "Green", "Red")
To concatenate text strings, use an ampersand (&). E.g.,
“Days remaining until Due Date: ” & {!days(due_date__c, today())}
FName__c & “ ” & LName__c
To check values selected in a multi-value pick list use the in and not in operators. E.g.,
Enabler_PickList__c not in "Technology; AI"
Risk_Severity__c in "High; Medium"
To filter a list or a view, use comparison operators. E.g.,
Headcount filter field: > 20
Estimated Value filter field: >= {!Minimum_Value__c}
Revenue__c filter field: <100 + !=10
Facility Number filter field: 23, 98, 426
Note: For filter values, a comma between the values is an “OR” separator and returns items with a match to any of the values. A plus sign between the values is an “AND” separator and returns items that match all of the values.
List of Operators
The table below provides a summary of all operators used by the Shibumi expression language.
Note: the syntax is case sensitive.
| Category | Operator | Syntax |
| Comparison | Equals | = |
| Comparison | Not Equals | != |
| Comparison | Greater than | > |
| Comparison | Greater than or equal | >= |
| Comparison | Less than | < |
| Comparison | Less than or equal | <= |
| Comparison | In | in |
| Comparison | Not In | not in |
| Concatenation | Concatenate Text | & |
| Arithmetic | Addition | + |
| Arithmetic | Subtraction | – |
| Arithmetic | Multiplication | * |
| Arithmetic | Division | / |
| Logical | And | and |
| Logical | Or | or |
| Filter | And | + |
| Filter | Or | , |