Formula - Budget vs. Actuals

J

Jason

Hello,
I'm in need of help to create a formula. Cummulative Budget verses
Cummalative Actuals with the intent to only display amount. Any help would be
greatly appreciated!

Jason
 
P

Paul Conroy

Jason, there are a number of OOB Earned value variables such as CPI, VAC etc
which may give you what you want. Check out the link below for some more
info on the available fields

http://office.microsoft.com/en-us/project/HA101567921033.aspx


If none of the system variables are usable for your requirement, then you
need to be more explicit around want you want the formula to achieve (ie
actual cost/work as a percentage of budgeted cost/work, graphical indicators
which display under/over budget and the logical behind the formula ie show
green when less than 95% of budget, Orange 95-105% and Red when over 105% !)
 
J

Jason

Thanks Paul. I'll check out the links over the next few days and see what I
can come up with.
 
Top