Custom Formula help
I'm pretty new to MS project and by no means a MS Office expert of any kind. I know nothing about programming, but I've managed to create a basic project Gantt chart for my employees. Here's my current struggle:
I am trying to create a formula to calculate "actual cost" by taking my "duration" multiplied by my "manpower" (Number2) and multiplying that by my daily rate per person (lets say 100 dollars an hour times 8 hours= 800).
When I right click on my "actual cost" column and go to "custom fields", I click the formula button and enter in my custom formula ([Duration]*[Number2])*800. The $ amount in the "actual cost" column comes out in the millions...it should be in the thousands.
I'm not sure if somehow the "duration" field and custom "number2" field somehow don't mesh and cant create a good formula together? or maybe I'm missing something.
Hopefully somebody with some Project 2013 knowledge can help me out.
Much appreciated
Jason
|