Problem with the RAG Status in Project

S

Santosh Matada

Hello,

I want to show the BRAG status (Basline RAG status) with graphical
indicators in my project plan using the "Baseline Date" column but
having issues as the graphical indicators are not displayed and the
same column (Baseline RAG Status) is showing as "0" for all the tasks.

Please can you assist. I am using the Formulae below -

Switch([% Complete]=100,3,[Finish]<[Current Date],2,[Finish]-[Baseline
Finish]<=1.5,0,[Finish]-[Basline Finish]<=13,1,[Finish]-[Baseline
Finish]>=14,2)

Graphical Indicators set to = 0 is GReen, 1 is Amber, 2 is Red and 3
is Blue.

Thanks.

S
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Formula for Overall Summary of Project Status 0
how to stop displaying field in project professional 2007 save dia 4
RAG status - graphical indicator 3
Using project indicators and the current date 4
Project Level RAG graphical indicator NOT driven from the schedule 2
Graphical Indicator displaying data instead of graphical indicator 9
Cost Indicator 7

Top