Setting Up Column Formulas
Advanced users can create new formulas, or edit existing formulas, using built-in functions. Siebel CRM On Demand Answers supports a wide variety of SQL-92 functions, as well as extensions to SQL-92. Available functions are presented in Using Functions in Analyses.
To edit or add a formula
- Within the Columns area of the Define Criteria page, click the Edit Formula button for a column whose formula you want to edit or add.
- Select the Column Formula tab.
- Select the Custom Headings check box if you want to change the table heading and column heading text.
- Modify the formula, as required, using the buttons below the Column Formula box.
- Select an aggregation rule from the Aggregation Rule drop-down list, as required.
- Select the Bins tab and combine multiple values or ranges into bins, if required. See "To combine multiple values or ranges into bins" below.
- Click OK.
In an analysis, you can also use functions and conditional expressions to present search results in a variety of ways.
To combine multiple values or ranges into bins
|