Dave
Fri Aug 10 08:26:40 CDT 2007
Hi, I think you are making this harder than you need to.
The steps I describe will:
- Display a red indicator for total slack between 0 and 1 days
- Display a green indicator for total slack between 0 and 5 days
- Display a yellow indicator for total slack greater than 5 days
Insert a new column "Duration1".
Right click on the header and click "Customise Fields".
Click on formula and enter [Duration] in the edit box. Click on OK to
exit the formula editing dialogue box.
Click on "Graphical Indicators". In the first column select "is less
than or equal to" for the first row, "is less than or equal to" for the
second row and "is greater than" for the third row.
In the second column enter 1d, 5d and 5d on the first, second and third
rows respectively.
In the third column select the red icon, the green icon and the yellow
icon for the first, second and third rows respectively.
Click on ok to exit the various dialogue boxes.
An alternative way is, as you allude to, to make a formula which
generates 0, 1 and 2 but this appears to overcomplicate things.
Hope this helps.
Craig Anthony wrote:
> Hi,
>
> Currently I am using Custom field Duration (1), renamed it item. I then set
> formula equals to [total slack]. I then use custom field Duration 2 and
> rename say x and formula is equals to 0. Thats all fine.
> When I go back to Duration (1) and set graphical indicaters under Test for
> 'Duration1' (renamed item) Then arrow down menu and use equals & value(s)
> Duration 2 and set image a red indicator. Next line I use greater than &
> value(s) Duration 2 and use a green indicator. Thats all fine.
> My problem is I want to display three indicators? Curretnly I have one
> indicator set as red, another set as green (which I have) but I only want it
> to be green between 1 & 5 - total slack. Anything above 5 total slack is set
> as a yellow indicator this is what I'm having problems with setting three
> indiators to the one project?
> I'm not sure I though of using a formula under function General Iff
> (expression, truepart, falsepart)....Any ideas?
>
>
>
>
> "Jan De Messemaeker" wrote:
>
>
>>Hi,
>>
>>Some advice about this.
>>First, it is interesting to use for this a custom duration field; then no
>>division by 8 nor 60 is necessary
>>Second, if you have to do the division anyway, use [Minutes per day] instead
>>of 8*60, it will adapt automatically if hours per day is not 8
>>Hope this helps,
>>
>>--
>>Jan De Messemaeker
>>Microsoft Project Most Valuable Professional
>>+32 495 300 620
>>For availability check:
>>
http://users.online.be/prom-ade/Calendar.pdf
>>"Dave" <not@here> wrote in message news:46bc04ec$1@mail.hmgcc.gov.uk...
>>
>>
>>>Insert a number column, Number1 say. Then add the formula
>>>
>>>[Total Slack]/60/8 (assuming your working day has 8 hours).
>>>
>>>The formula is entered by right clicking on the Number1 column heading and
>>>then on Customise Fields. Clock on the formula button and click through
>>>all the warnings. Division by 60 is necessary to convert from minutes to
>>>hours and division by 8 converts to working days.
>>>
>>>Then in the bottom of the Customise Fields dialogue box, click on
>>>Graphical indicators and choose the tests, values and icons from the
>>>various drop down boxes that are displayed.
>>>
>>>I note that below you are using green for what you descibe as non-critical
>>>and yellow for the most relaxed conditions so I wonder if that is what you
>>>really meant but that is a minor detail.
>>>
>>>
>>>Craig Anthony wrote:
>>>
>>>>I'm wanting to find a way to set a formula under function to allow the
>>>>programme to show 3 different coloured indicators to represent RED for
>>>>critical (total slack 0), GREEN for non-critical (total slack between
>>>>1-5) and YELLOW between 5 & greater within the programme so I can
>>>>progressively monitor the float within the detailed Ganett view?
>>>>Any help with the formula would be greatly appreciated
>>
>>
>>