Alex has attended:
Project Intermediate course
Calculated fields
How do I create field that does a calculation to add mark up on recourse costs - shown separately
RE: calculated fields
Hi Alex
Thanks for your question.
Here's a simple example to show how to create a 'Mark Up' calculated field.
1. Start by creating a project with Task 1 and task 2 with duration 5 days and 3 day. Link the tasks together.
2. View the Resource Sheet and add Contractor 1 and Contractor 2 with standard rates of £300/day.
3. Return to the Gantt view and select the duration column, choose Insert, Column and click Cost.
4. Select duration again and insert Cost1.
5. To create the calculation right click Cost1 and choose Custom Fields. In the Custom Fields dialog choose Rename Field and type Mark Up.
6. Click Formula and type
[Cost]*1.2
Or whatever mark up you require (50% would be [Cost]*1.5)
7. Press ok twice and you should see the Mark Up calculation.
Task Name Cost Mark Up
Task 1 £1,500 £1,800
Task2 £900 £1,080
The Mark UP can be added to reports. Let me know if you need this and I will add the instructions.
Hope that gets you started for now
Regards
Doug
Best STL
RE: calculated fields
Hi Doug
Thats really helpful, thank you. It would be great if you could share how to add this to a report.
Thanks again
Alex
RE: calculated fields
Hi Doug
Thats really helpful, thank you. It would be great if you could share how to add this to a report.
Thanks again
Alex
RE: calculated fields
Hi Alex
Glad that helped you.
With Project 2010 reports can be customize by inserting custom fields into the table the report is based on. For example to view the Mark Up calculation in the Cost, Budget report do the following:
1. Choose View, Tables, Cost
2. Right click the column to the right of Total Cost (Baseline) and choose Insert Column. Choose Cost1 (Mark Up)
3. Now select Project, Reports, Cost, Budget and the Mark Up field will appear.
If you want to change the % increase choose Project, Custom Fields, Cost 1 (Mark UP) and click the Formulas button. You can then edit and update the formula [Cost]*1.2
With Project 2013 or 2016 a custom field can be added by selecting a table in report design and adding it from the Field List.
For example, select Reports, Dashboards, Cost Overview.
Clicking the Status table and add the custom field from the Field List (Costs, Custom). To re position right click the field and choose Move Up.
Regards
Doug
Best STL
