Project 2010 Bible

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% ...