You insert fields into formulae using the Field button on the Formula Properties dialog. A menu appears, from which you can choose the field that you want to insert into the formula. Once you have selected a field, the Select Object dialog appears. You use this dialog to specify the object about which you want the field to display information.
The list of fields that you can insert into formulae is the same as the list of fields that you can display in the spreadsheet.
Representing fields within formulae
As well as inserting fields into formulae by selecting them from the menu that appears when you click the Field button on the Formula Properties dialog, you can type the names of fields directly into formulae. If a field name comprises more than one word, you must remove all spaces from the field name when using it in a formula. For example, you would refer to the Actual Cost field using the word ActualCost. Note that character case is disregarded for field names in formulae, so you could refer to the Actual Cost field as ActualCost, actualcost, ACTUALCOST, etc.
Do not surround the names of fields with either single or double quotation marks when you use them in formulae. The names of some EVA fields include an acronym in parentheses - for example, Cost Variance (CV) or Forecast at Completion (FAC). Do not include the acronyms or the parentheses when using these fields in formulae.
Spreadsheet fields can take a selection of parameters. In most cases these parameters are optional, but some fields require certain parameters to be supplied. For example, the Earned Value field requires a baseline and a date to be supplied as parameters. Parameters should be included in parentheses directly after the field name within formulae, for example EarnedValue(1,1047). In this case, the parameters are assumed to be the baseline ID and progress period ID (which provides the required date) respectively.
The easiest way to provide the required parameters for fields is to insert the fields into formulae by selecting them from the menu that appears when you click the Field button on the Formula Properties dialog and using the Select Object dialog to specify the objects about which you want fields to display information.