Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.
Arithmetic Operators
Use arithmetic operators to perform addition, subtraction, multiplication, division, and
modulo operations.
| Operator | Description |
|---|---|
| + | Plus |
| - | Minus |
| * | Multiplication |
| / | Division |
| % | Modulo |
Example
You want to charge each of your accounts 5% of their opportunities as a fee. Create a query that multiplies the Amount field by .05. This query will resemble the following:
1q = load "opportunity";
2q = group q by 'Account.Name';
3q = foreach q generate 'Account.Name' as 'Account.Name', sum('Amount') * 0.05 as 'Fee';
4q = order q by 'Fee' desc;
5q = limit q 2000;