Print      Open PDF Version of Online Help


Previous Topic

Next Topic

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

  1. 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.
  2. Select the Column Formula tab.
  3. Select the Custom Headings check box if you want to change the table heading and column heading text.
  4. Modify the formula, as required, using the buttons below the Column Formula box.
  5. Select an aggregation rule from the Aggregation Rule drop-down list, as required.
  6. Select the Bins tab and combine multiple values or ranges into bins, if required. See "To combine multiple values or ranges into bins" below.
  7. 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

  • On the Bins tab, add and name bins to combine multiple values or ranges of values from a given column into bins.

    All instances of the different values that make up the bin in the result set will be replaced by the bin name. Aggregations are performed accordingly as well.


Published May 2008