Cachorrita
Technical User
I can't write code to save my life so I'm trying to do the following: I have a very basic Programme plan with a Baseline Finish date and Forecast Finish Date [Date1]. I have put in a RAG column and this formula (which I found on a website but works like a dream):
IIf([Date1]>99999,"None",DateDiff("d",[Baseline Finish],[Date1]))
Which has successfully calculated my RAG based on criteria I've entered into the Graphical Indicators field as follows:
equals - None - green circle
is less than or equal to - 6 - green circle
is less than or equal to - 13 - yellow circle
is greater than or equal to - 14 - red circle
HOWEVER, in addition to the formula above I want it so that if there is no date in the [Date1] Field but the [% Complete] is 100, then the RAG will be "Complete". The graphical indicator for this will be blue ie equals - Complete - Blue Circle.
Could anybody have a go at writing my code so that it includes this? I've had a go but my brain is melting.
IIf([Date1]>99999,"None",DateDiff("d",[Baseline Finish],[Date1]))
Which has successfully calculated my RAG based on criteria I've entered into the Graphical Indicators field as follows:
equals - None - green circle
is less than or equal to - 6 - green circle
is less than or equal to - 13 - yellow circle
is greater than or equal to - 14 - red circle
HOWEVER, in addition to the formula above I want it so that if there is no date in the [Date1] Field but the [% Complete] is 100, then the RAG will be "Complete". The graphical indicator for this will be blue ie equals - Complete - Blue Circle.
Could anybody have a go at writing my code so that it includes this? I've had a go but my brain is melting.
