RAG Statuses are calculated using various scores and settings. The main ones are:


• Green RAG Status: If the value calculated for a RAG Status is >= 2.5, then the RAG Status will be set to 3. This

is the value than represent Achieving or Green RAG Status.


• Amber RAG Status: If the value calculated for a RAG Status is < 2.5 and >= 1.5, then the RAG Status will be

set to 2. This is the value than represent Amber RAG Status.


• Red RAG Status: If the value calculated for a RAG Status is < 1.5 and > 0, then the RAG Status will be set to 1.

This is the value than represent Red RAG Status.


For those RAG Statuses with a value of 0, then they can be either Grey or Blue .

Both an Actual and Forecast are needed for a RAG Status to be calculated, and one or both of these will be

missing.


• Grey = Missing Actual value. Grey is when the RAG Status could not be calculated as Red/Amber or Green as

there is no Actual value. It is blank. Note that a zero value is a valid value.


• Blue = There is an Actual value, but no Forecast. Blue is when the RAG Status could not be calculated as

Red/Amber or Green as there is no Forecast value/ it is blank, yet there is an Actual value.


A flag can also be set to identify a RAG Status as always Blue for a Measure: Use a RAG Status other than

Blue. Select this to only show a Blue RAG Status.


N.B. To help take some of the thinking out of questions like the following there is an excel attached
- What Green/Amaber and Amber/Red Parameter settings should I use to give the RAG Status expected?
- Why isn't the RAG Status coming out as expected?

There may be other factors at play that influence the RAG Status (for example different Calculation Approaches and settings such as Parent/Child relationships).