How to Compute Values from a Formula

General

The Compute Values function allows values for cells to be generated based on other record data, by evaluating a user-defined formula.

Select the cells to populate with generated values.
Select Compute Values from the Context Menu or Edit Menu.
The Compute Values from Formula dialog box will be displayed, with a formula field for each column in the selection.
Enter a valid formula for each column.

Note: If you plan to reuse any formulae at a later time, keep a copy of them in a safe place - the dialog only remembers the most recently used formula.

Example in Instrument Manager (with formulae entered):
Click OK.

The formulae for each column will be evaluated for each record with selected cells, and the results written into the selected cells.

If there is a syntax error in your formula, an descriptive error will be shown, and you will be able to return to the dialog to correct the error.

Note: Field names are not checked - non-existent fields that are referenced will be treated as a column with no data (all blanks).