A script-enabled browser is required for this page to function properly.

About formula columns

A formula column is a user-created column that gets its data from a PL/SQL function or expression, a SQL statement, or a combination of these.

A formula column performs a user-defined computation on the data of one or more column(s), including placeholder columns. For example, :ITEMTOT *.07 is a formula that performs a computation on one column, while :SAL + :COMM performs a computation using two columns in a record. You create formulas in PL/SQL using the PL/SQL Editor.

Note:   Formula columns should not be used to set values for parameters.

For a detailed example of building a report that includes formulas, see the chapter titled "Building a Group Left Formula Report" in the Oracle Reports Building Reports manual, available on the Oracle Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html).

See also

About formulas

Creating or editing a formula column

About database columns

About summary columns

About placeholder columns