Using Functions in AnalyticsSQL functions perform various calculations on column values. This section explains the syntax for the functions supported by Oracle CRM On Demand. It also explains how to express literals. There are aggregate, string, math, calendar date/time, conversion, and system functions. You can use functions anywhere that formulas or SQL expressions are allowed. For example:
Formula NamesWhen referring to a column in a function, you must use its internal formula name. All columns have two different names:
The following table provides examples of formula names that correspond to specific folder and display names for a column.
Finding the Formula NameTo determine the formula name for a column, first add the column to a report. Click Edit Formula [fx], and then the Column Formula tab in the resulting dialog box. The formula name for that column can be found in the Column Formula text box. TIP: When the cursor is in the Column Formula dialog box, clicking a column in the Action bar inserts the column's formula name directly into the text box at the cursor location (but the column is not added to the list of columns for the report). This shortcut works only for the Column Formula dialog box, not for other dialog boxes where SQL can be entered. For more information, see the following topics: |
Published 6/21/2021 | Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices. |