Formulae

A formula is a user-calculated expression that defines the information that is displayed in a spreadsheet column. You can construct formulae to display practically any information in the spreadsheet: formulae can reference spreadsheet fields, user-defined fields and tables, variable dates, etc, and can take information from the live data or from a specified baseline. On top of this, you can construct formulae to perform calculations on project data. For example, you could construct a formula to subtract the baseline cost from the actual cost in the live data, then display the result in a format of your choosing; you could construct a formula to calculate what percentage of total project costs the cost of each individual task represents.

You create formulae in Library Explorer, then use the Table Definition Properties dialog to include them in tables which you can display in the spreadsheet; alternatively, you can display formulae in the spreadsheet by right-clicking a spreadsheet column, selecting Field and selecting a formula from the Formulae submenu.

You can use formula categories to classify the formulae in your project. Categorising formulae in this way makes it easier to find the formula you are looking for, for example when selecting a formula to display in a spreadsheet column.

You can edit the properties of a formula by editing options on the Formula Properties dialog. To access help for the Formula Properties dialog, press F1 while viewing the dialog.

Related Topics:

Using formulae in spreadsheet columns

Example formulae

Formula categories