Creating Calculation Fields

To create a calculation field:

1	Choose Insert > New Field or press Control-N.

2	Choose Calculation.

3	Click Continue.

4	Name the field.

5	Build a formula for your calculation.

 

To add	Do this
A reference to a field	In the Available Fields list, double-click a field name.
A mathematical or text operator	Click an operator button or type an operator in the formula.
The current date	Click Today to insert the current date.
The current time	Click Now to insert the current time.
A pre-formatted value	Click Value, then select a value from the list. Replace the pre-formatted value with the value you want.

6	Choose the correct data type for the result you want and set any other options.

7	Click Create.

The new field is added to the Fields pane and the current form.

Tip  If you are unfamiliar with creating calculations, click Show Examples to see and experiment with examples of calculations.

 

To create a calculation in a simple list field:

1	Click the pop-up menu in a column header.

2	Choose Change To > Calculation.

3	Choose Edit Column Name to open the calculation dialog.

4	Build a formula for your calculation as described in steps 5 and 6 in the procedure above.

 

Home > Using Fields > Creating Fields > Creating Calculation Fields