| Print Open PDF Version of Online Help

#### Setting Up Column Formulas Advanced users can create new formulas, or edit existing formulas, using built-in functions. Oracle CRM On Demand supports a wide variety of SQL-92 functions, as well as extensions to SQL-92. For information about the available functions, see Using Functions in Analytics. To edit or add a formula In the Criteria tab, pull down the menu for the desired field and choose Edit formula. In the Edit Column Formula dialogue box, 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 check 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. For more information, see the To combine multiple values or ranges into bins procedure in this topic. Click OK. In an analysis, you can also use functions and conditional expressions to present results in a variety of ways. To combine multiple values or ranges into bins In the Edit Column Formula dialogue box, select the Bins tab. Click Add Bin, enter or select the values or ranges of the value that you want to combine into the bin, then click OK. In the Edit Bin Name dialogue box, enter the name for the bin. Repeat steps 2 and 3 until you have added all the bins that you want. 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 August 2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.