Site search powered by Google

12.8. Defining new columns

The application allows a user to define his own formula driven columns giving him the power to perform some spreadsheet like analysis or planning and also enabling him to create a variety of reports based on the columns created by him.

To define a new column to be displayed in the Attribute table view :

In the Attribute table popup, click on the Define/change/delete columns button. The Define column window appears where the existing columns and their corresponding variable names are listed on the left. These variable names are used in the formulas that specify a column's value, as explained below.

To define a new column:

Setting a formula: The formula defines what is to be displayed in the new column. In the formula, to refer to the a column in the Column name list on the left, use the corresponding entry in the Variable list . We give some examples below.

In the examples we assume that the variable name corresponding to Estimated Effort is c29v , to Budgeted Effort is c10v

The following formula defines a column which shows the difference between budgeted and estimated effort.

The following formula defines a column which displays Over budget for those rows where the estimated effort exceeds the budgeted effort.

As a convenience, clicking on a variable name in the Variable list causes that variable name to be inserted into the Formula textfield. The formulas that can be used are described in section Formulas .

For each column defined you can also specify the output type. For output types Date and Time period , you may further choose the display format.