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