Appendix C. Available Fields and Functions for Custom Field Formulas

IN THIS APPENDIX

  • Task fields

  • Resource fields

  • Functions available

This appendix contains three tables that help you identify the fields and functions you can use when creating formulas to include in custom fields. Table C.1 contains a list of all the Task fields you can include in a formula. The fields are listed according to the respective sub-menus on which they appear when you click the Fields button in the Formula dialog box. Table C.2 contains the same information for Resource fields. In each of these tables, the first column contains a field category. The second column contains either fields within the category or those that occupy a subcategory. If the second column contains a subcategory, then the fields appear in the third column. Table C.3 lists the functions you can include in a formula, as well as a description of each function's purpose.

Table C.1. Task Fields Available for Custom Field Formulas

Category

Subcategory or Field

Field

Cost

Actual Cost

 
 

Actual Overtime Cost

 
 

ACWP

 
 

Baseline Cost

Baseline Cost, Baselinel Cost-BaselinelO Cost, Baseline Budget Cost, Baseline 1 Budget Cost-BaselinelO Budget Cost

 

BCWP

 
 

BCWS

 
 

Budget Cost

 
 

Cost

 
 

Cost Variance

 
 

CPI

 
 

Custom Cost

Costl-CostIO

 

CV

 
 

CV%

 
 

EAC

 
 

Enterprise Custom Cost

Enterprise Costl — Enterprise Costl 0

 

Enterprise Project Custom Cost

Enterprise Project Costl — Enterprise Project Costl 0

 

Fixed Cost

 
 

Overtime Cost

 
 

Remaining Cost

 
 

Remaining Overtime Cost

 
 

SPI

 
 

SV

 
 

SV% ...

Get Project 2010 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.