Question:
I have a row with many milestones (20 or so). I would like to calculate the difference between two specific milestones on each row of my schedule. (Start up date and First Delivery Date) Any ideas?
|
Answer:
This is a perfect application of Milestones Professional's Date from Symbol Automation tag Column.
To solve your problem you will
-
On each row, tag both symbols you plan to use. Tag the first one with 1,Date1. Tag the second one with 1,Date2. (To enter an automation tag, click once on the symbol. Next click the Symbol Links tab on the toolbar and type in the Automation tag field.) Note that the number 1 is an identifier for the symbol. If you are not linking your schedule for future refresh, the number is insignificant but must still be entered for this process to work.
-
Insert a Date from Symbol Automation tag column.
-
In the Symbol Automation tag choice dialog box which appears, choose Date1.
-
Set the Column Heading for this column to Start up.
-
Insert a second Date from Symbol Automation tag Column.
-
In the Symbol Automation tag choice dialog box which appears, choose Date2.
-
Set the Column Heading for this column to First Delivery.
-
Insert a Calculation/Indicator column.
-
In the Calculations Settings dialog box which appears, set the calculation as shown:
|