Hi,
I have 4 columns with percentages in them, which I was like to automatically calculate a Red, Amber or Green status from.
Two of the columns show Forecast vs Baseline for the current month and year to date and the other two columns show the same data, but include risk.
The RAG rules I need to calculate are as follows:
RED: IF: Forecast vs Baseline is less than 90% or greater than 110% and Forecast vs Baseline inc risks is less than 80% or greater than 110%
AMBER: IF: Forecast vs Baseline is between 90% and 95% and between 105% and 110% and Forecast vs Baseline inc risks between 80% and 90% or between 105% and 110%
GREEN: IF: Forecast vs Baseline between 95% and 105% and Forecast vs Baseline inc risks between 90% and 105%
I have attached the example data.
Thanks
Rob
Bookmarks