RAG formula - problem with summary tasks

[Adam 1980]

Hello,

I'm currently using a formula allowing me to show trafiic lights (RAG). My formual also works well for the subtasks, but the highest level summary tasks shows the RAG status for the overall duration date. What I need is the RAG Status on the summery task to reflect the the subtask with the shortest time left,the subtask that will expire first. e.g. if there are 6 subtasks under the summery level task, from which 5 will expire after 2 months and are on GREEN Status and 1 will expire within next 5 days and is AMBER, because it approuching deadline, I want the high level summery task to be AMBER and reflect the status of the task which is on AMBER (the one expiring in 5 days). The formula im using is pasted below.

IIf([% Complete]<100,IIf([Finish]>Now()+7, "OK", IIf(Now()>[Finish],"Over","Nearly Expired")),"Complete")

Could you help please? It will be very much appreciated.

Many Thanks

Adam

[JAMES_911]

To set a graphical indicator, insert a custom field such as Text1. Right click on the field, select Customize Fields. In the dialog that opens, there is a graphical indicator button. That button will expose a window where you can set some formulars such as CPI>0.95 show Green, etc. It is pretty intuitive once you get there. The Text1 indicator will display regardless even if the SPI or CPI columns are hidden. You can apply this same logic to any other formula values you may use, just set the custom formula to also calculate on the summary rows in the custom fields dialog box.