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

Defined (and Computed) Column Examples

Suppose you wanted to project a budget for next year's net pay (NET_PAY_NEXT) assuming a 10% salary increase. You could enter the following in the Expression field:

(SALARY*1.1) + COMMISSION

Or, if you wanted to review a 10% increase in both salary and commission, you could enter:

(SALARY+COMMISSION) * 1.1

Since NET_PAY is SALARY+COMMISSION, this is the same as:

NET_PAY * 1.1

You can also create a defined column that displays the difference between the current net pay and next year's projections. Call this column VARIANCE, and define it as:

NET_PAY_NEXT - NET_PAY

When you define new columns, the base columns described in your expression need not exist in the underlying database, although they should ultimately be derived from columns in the underlying table. VARIANCE, for example, is the same as:

((SALARY+COMMISSION) * 1.1) - (SALARY+COMMISSION)


About Defined (and Calculated) Columns

Building a New Query

About the Query Window

Defining a Column

Removing a Column