Operators
There are four mathematical operators in calculated fields: add, subtract,
multiply, and divide. Use brackets to group parts of your calculations.
Only numeric fields (such as integer fields) can be used in numeric calculations.
If an operator is used in a string-calculated field, it will act as just
another character. Operators in string calculated fields will not perform
any operations.
Examples:
- Numeric
calculation: Opportunity.Salespotential * Opportunity.Closeprobability
/ 100. The resulting weighted sales figure would be 100, if Sales Potential
is 200 and Close Probability is 50% (stored as 50, not as 0.5).
- Numeric
calculation with brackets: (Opportunity.Salespotential * Opportunity.Closeprobability
/ 100) + 5. The resulting figure would be 105, if Sales Potential is 200
and Close Probability is 50% (stored as 50, not as 0.5).
- String
Calculation: Opportunity.Status + Opportunity.Account. The result is Won
+ Big Account if the status is Won and the Account is Big Account.
Related Topics
Query Builder Overview