View Single Post
 
Old 07-13-2015, 02:29 PM
JulieS JulieS is offline Windows 7 64bit Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome. I'm not a "sir" but rather Julie - a Ma'am if you must

All of the earned value data (with the exception of SPI and CPI) are in cost terms. So, you can use some of the spare cost fields (Cost1, Cost2) as needed to perform the calculations.

Add the field to a table (left side of the view) and then right click on the column heading and select "Custom Field".

Click the option for Formula and enter the formula. For example for BAC - the formula would be
[EAC]-[AC]

Field names are enclosed in square brackets. For multiplication use * instead of x.
Reply With Quote