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, the operator acts as just another character. Operators in string calculated fields cannot perform any operations.

Examples:

  • Numeric calculation: Opportunity.Salespotential * Opportunity.Closeprobability / 100. The resulting weighted sales figure must 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 must 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