Microsoft® Project 2007 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 that you can use when creating formulas to include in custom fields. Table C-1 contains a list of all the Task fields that you can include in a formula. The fields are listed according to the submenu on which they appear when you click the Fields button in the Formula dialog box. Table C-2 contains the same information Tor Resource fields. In each of these tables, the first column contains a field category. The second column contains either fields within the category or a subcategory. If the second column contains a subcategory, then the fields appear in the third column. Table C-3 lists the functions that you can include in a formula, as well as a description of the 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, Baseline1 Cost - Baseline1 0 Cost, Baseline Budget Cost, Baseline 1 Budget Cost -Baseline10 Budget Cost
	BCWP
	BCWS
	Budget Cost
	Cost
	Cost Variance
	CPI
	Custom Cost	Cost1 - Cost10
	CV
	CV%
	EAC
	Enterprise Custom Cost	Enterprise Cost1 -Enterprise Cost10
	Enterprise Project Custom Cost	Enterprise Project Cost1 - Enterprise Project Cost10
	Fixed Cost
	Overtime Cost
	Remaining Cost
	Remaining Overtime Cost
	SPI
	SV
	SV%
	TCPI
	VAC